Catherine, I think Carol meant Control + 1. Tab into the Category list and DownArrow to Fractions, then Tab again into a list of the possible formats you can choose from. Steve -----Original Message----- From: access-uk@xxxxxxxxxxxxx [mailto:access-uk@xxxxxxxxxxxxx] On Behalf Of catherineturner2007@xxxxxxxxxxxxxx Sent: 20 August 2008 13:10 To: access-uk@xxxxxxxxxxxxx Subject: [access-uk] Re: Excel help please Hi Carol, When I press Control f1 nothing seems to happen... Catherine On 8/20/08, Carol Pearson <carol.pearson29@xxxxxxxxxxxxxx> wrote: > Catherine, > > Select the column you want in the fraction format and type CTRL+F1 and > you'll find a fraction and decimal option there. > > If you can't get it working from this description, I may be able to help > further, given a bit of time and some playing. > > HTH: > > -- > Carol > carol.pearson29@xxxxxxxxxxxxxx > > On Tuesday, August 19, 2008 6:35 PM (UK time), > catherineturner2007@xxxxxxxxxxxxxx at catherineturner2007@xxxxxxxxxxxxxx > said: > >> Hi, >> >> Thanks - this kind of helps but not really as I've realised I don't >> want Excel to treat 10/1 as a piece of text or date, but rather as a >> fraction. >> >> Basically what I'm wanting to do is make it convert odds expressed as >> fractions into odds expressed as decimals. So if I type 10/1 in cell >> a1, I then want to do a formula in A2 which is a1 +1. Whatever the >> fractions are I put in row 1, I want it to do a sum on them and add 1. >> >> I've also now realised that even if I just type 10 it converts it >> into 10 Jan... >> >> Catherine >> >> On 8/15/08, Griffiths, Steve <Steve.Griffiths@xxxxxxxxxxx> wrote: >>> Or, put an apostrophe before the number and Excel will treat it as >>> text. So '1/3 will appear as 1/3 in the cell. >>> >>> Steve >>> >>> -----Original Message----- >>> From: access-uk@xxxxxxxxxxxxx [mailto:access-uk@xxxxxxxxxxxxx] On >>> Behalf Of David W Wood >>> Sent: 14 August 2008 15:59 >>> To: access-uk@xxxxxxxxxxxxx >>> Subject: [access-uk] Re: Excel help please >>> >>> Highlight the cell or range of cells in question, >>> Ctrl+1 (format cells) >>> Tab (you will probably hear 'date' spoken). >>> Press t until you hear 'text' spoken. >>> Press 'enter' >>> Job done >>> >>> >>> >>> David W Wood >>> >>> GUILDFORD PHYSIOTHERAPY AND SPORTS CLINIC >>> MATTHEWS HOUSE >>> 85 EPSOM ROAD >>> GUILDFORD >>> SURREY GU1 3PA >>> >>> T: 01483 575876 (APPOINTMENTS) >>> 302691 (ALL OTHER INQUIRIES) >>> >>> E: reception@xxxxxxxxxxxxxxxxxxx >>> W: http://tinyurl.com/5wptcp >>> >>> ____________________ >>> DISCLAIMER >>> The information contained in this e-mail is strictly confidential >>> and is intended solely for the individual/s to whom it is addressed. >>> If you are not >>> the intended recipient or have received this e-mail in error please >>> delete >>> it immediately. Any disclosure including but not withstanding >>> reading copying or distribution of all or part of the information >>> contained herein >>> is strictly prohibited and may be unlawful. Although this email and >>> any attachments are believed to be free of any virus or any other >>> defect which >>> might affect any computer or system on which they are received and/or >>> opened >>> it is the responsibility of the recipient to ensure that they are >>> virus free >>> and no responsibility is accepted by The Guildford Physiotherapy and >>> Sports >>> Clinic for any loss or damage arising in any way from receipt or use >>> thereof. Any opinions or advice contained in this email are not >>> necessarily those of The Guildford Physiotherapy and Sports Clinic or >>> any >>> individual or individuals working or acting on its behalf. >>> >>> All prices shown are in pounds sterling and exclude VAT, Delivery and >>> Expense charges unless otherwise stated. >>> -----Original Message----- >>> From: access-uk@xxxxxxxxxxxxx [mailto:access-uk@xxxxxxxxxxxxx] On >>> Behalf Of >>> Catherine Turner >>> Sent: Thursday, August 14, 2008 3:46 PM >>> To: Access-UK >>> Subject: [access-uk] Excel help please >>> >>> Hi, >>> >>> How can I stop Excel from converting 1/3 (one slash three) into a >>> date automatically? I just want it to stay as 1/3. I suppose this >>> is in auto format somewhere but I can't figure out where... >>> >>> Catherine >>> ** To leave the list, click on the immediately-following link:- >>> ** [mailto:access-uk-request@xxxxxxxxxxxxx?subject=unsubscribe] >>> ** If this link doesn't work then send a message to: >>> ** access-uk-request@xxxxxxxxxxxxx >>> ** and in the Subject line type >>> ** unsubscribe >>> ** For other list commands such as vacation mode, click on the >>> ** immediately-following link:- >>> ** [mailto:access-uk-request@xxxxxxxxxxxxx?subject=faq] >>> ** or send a message, to >>> ** access-uk-request@xxxxxxxxxxxxx with the Subject:- faq >>> >>> No virus found in this incoming message. >>> Checked by AVG. >>> Version: 7.5.524 / Virus Database: 270.6.3/1610 - Release Date: >>> 13/08/2008 >>> 16:14 >>> >>> >>> No virus found in this outgoing message. >>> Checked by AVG. >>> Version: 7.5.524 / Virus Database: 270.6.3/1610 - Release Date: >>> 13/08/2008 >>> 16:14 >>> >>> >>> ** To leave the list, click on the immediately-following link:- >>> ** [mailto:access-uk-request@xxxxxxxxxxxxx?subject=unsubscribe] >>> ** If this link doesn't work then send a message to: >>> ** access-uk-request@xxxxxxxxxxxxx >>> ** and in the Subject line type >>> ** unsubscribe >>> ** For other list commands such as vacation mode, click on the >>> ** immediately-following link:- >>> ** [mailto:access-uk-request@xxxxxxxxxxxxx?subject=faq] >>> ** or send a message, to >>> ** access-uk-request@xxxxxxxxxxxxx with the Subject:- faq >>> >>> >>> >>> -- >>> DISCLAIMER: >>> >>> NOTICE: The information contained in this email and any attachments >>> is confidential and may be privileged. If you are not the intended >>> recipient you should not use, disclose, distribute or copy any of the >>> content of it or of any attachment; you are requested to notify the >>> sender immediately of your receipt of the email and then to delete it >>> and any attachments from your system. >>> >>> RNIB endeavours to ensure that emails and any attachments generated >>> by its staff are free from viruses or other contaminants. However, >>> it cannot accept any responsibility for any such which are >>> transmitted. We therefore recommend you scan all attachments. >>> >>> Please note that the statements and views expressed in this email and >>> any attachments are those of the author and do not necessarily >>> represent those of RNIB. >>> >>> RNIB Registered Charity Number: 226227 >>> >>> Website: http://www.rnib.org.uk >>> >>> >>> >>> This message has been scanned for viruses by BlackSpider MailControl >>> - www.blackspider.com >>> ** To leave the list, click on the immediately-following link:- >>> ** [mailto:access-uk-request@xxxxxxxxxxxxx?subject=unsubscribe] >>> ** If this link doesn't work then send a message to: >>> ** access-uk-request@xxxxxxxxxxxxx >>> ** and in the Subject line type >>> ** unsubscribe >>> ** For other list commands such as vacation mode, click on the >>> ** immediately-following link:- >>> ** [mailto:access-uk-request@xxxxxxxxxxxxx?subject=faq] >>> ** or send a message, to >>> ** access-uk-request@xxxxxxxxxxxxx with the Subject:- faq >>> >>> >> ** To leave the list, click on the immediately-following link:- >> ** [mailto:access-uk-request@xxxxxxxxxxxxx?subject=unsubscribe] >> ** If this link doesn't work then send a message to: >> ** access-uk-request@xxxxxxxxxxxxx >> ** and in the Subject line type >> ** unsubscribe >> ** For other list commands such as vacation mode, click on the >> ** immediately-following link:- >> ** [mailto:access-uk-request@xxxxxxxxxxxxx?subject=faq] >> ** or send a message, to >> ** access-uk-request@xxxxxxxxxxxxx with the Subject:- faq > > ** To leave the list, click on the immediately-following link:- > ** [mailto:access-uk-request@xxxxxxxxxxxxx?subject=unsubscribe] > ** If this link doesn't work then send a message to: > ** access-uk-request@xxxxxxxxxxxxx > ** and in the Subject line type > ** unsubscribe > ** For other list commands such as vacation mode, click on the > ** immediately-following link:- > ** [mailto:access-uk-request@xxxxxxxxxxxxx?subject=faq] > ** or send a message, to > ** access-uk-request@xxxxxxxxxxxxx with the Subject:- faq > > ** To leave the list, click on the immediately-following link:- ** [mailto:access-uk-request@xxxxxxxxxxxxx?subject=unsubscribe] ** If this link doesn't work then send a message to: ** access-uk-request@xxxxxxxxxxxxx ** and in the Subject line type ** unsubscribe ** For other list commands such as vacation mode, click on the ** immediately-following link:- ** [mailto:access-uk-request@xxxxxxxxxxxxx?subject=faq] ** or send a message, to ** access-uk-request@xxxxxxxxxxxxx with the Subject:- faq ** To leave the list, click on the immediately-following link:- ** [mailto:access-uk-request@xxxxxxxxxxxxx?subject=unsubscribe] ** If this link doesn't work then send a message to: ** access-uk-request@xxxxxxxxxxxxx ** and in the Subject line type ** unsubscribe ** For other list commands such as vacation mode, click on the ** immediately-following link:- ** [mailto:access-uk-request@xxxxxxxxxxxxx?subject=faq] ** or send a message, to ** access-uk-request@xxxxxxxxxxxxx with the Subject:- faq