Yes, Catherine, I remember. Having selected your column with CTRL+Splace, then CTRL+1 (figure) takes you into various tabs and by default I think it lands on Number tab. The first thing you reach, if you tab once, is a list of various types of numbering which you might like to set. Give it a "play around" and I think it will answer some of your questions. <SMILE> It may bring up lots more and I don't use EXCEL too much these days, but someone will shed light if you need more answering that I can't manage. Cheers now. -- Carol carol.pearson@xxxxxxxxxxxx -----Original Message----- From: access-uk@xxxxxxxxxxxxx [mailto:access-uk@xxxxxxxxxxxxx] On Behalf Of Catherine Turner Sent: Sunday, February 05, 2006 5:11 PM To: access-uk@xxxxxxxxxxxxx Subject: [access-uk] Re: Excel question Hi Carol, It's been ages since you sent this mail so don't know if it rings any bells now but... I was having problems formatting some cells in Excel. You said press control space to select the entire column, then control f1 and choose "Text". I'm formatting the cells how I want them now by pressing ' apostrophe before typing the phone numbers, so got around the problem I originally wrote about. But I just wanted to say - pressing Control space did select the column. But pressing Control f1 didn't seem to do anything at all. What's Control F1 supposed to do? Catherine > -----Original Message----- > From: access-uk@xxxxxxxxxxxxx [mailto:access-uk@xxxxxxxxxxxxx]On > Behalf Of Carol Pearson > Sent: 19 January 2006 21:15 > To: access-uk@xxxxxxxxxxxxx > Subject: [access-uk] Re: Excel question > > > Catherine, > > Go to the column where you have the figures, press CTRL+Space to > highlight the column, then CTRL+F1 and select the "Text" option at the > bottom. > > HTH: > > > -- > Carol > carol.pearson@xxxxxxxxxxxx > > > > -----Original Message----- > From: access-uk@xxxxxxxxxxxxx [mailto:access-uk@xxxxxxxxxxxxx] On > Behalf Of Patricia Fraser > Sent: Thursday, January 19, 2006 4:58 PM > To: access-uk@xxxxxxxxxxxxx > Subject: [access-uk] Re: Excel question > > > Hi Catherine, > > > For some reason I still can't get into the Format/Cells dialog - > > have made sure I definitely finished the edit > first. > > Hi Catherine - I'm stumped. I don't think I can help here without > having a copy of the actual spreadsheet - if you want to, you could > send it offlist and I will take a look. Are you having trouble getting > to any of the other menus? > > > With the scientific notation - so is that what shows up visually in > > the cell? Is there a choice about how Excel displays this/how JAWS > > reads it? > > The Scientific notation shows up visually in the cell as 1.60E+09 > (that's our phone number at TVS), but in the part at the top of the > sheet, which is the entry field, it shows 1604792777 - the zero has > dropped off. The format needs to be changed to Text to keep the > leading zero, and then it will display/speak properly. Scientific is > the only one that does this particular notation. > > Have you tried putting the apostrophe at the beginning of > the number? This is a shortcut to tell Excel that this cell is to be > formatted as Text. I am wondering whether, if you do that, Excel will > then let you into the Format/Cells menu. > > All the best! > -- > Patricia Fraser > Braille Development > Techno-Vision Systems Ltd > +44(0)1604 792 777 > ** 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 Free Edition. > Version: 7.1.375 / Virus Database: 267.14.20/234 - Release Date: > 18/01/2006 > > > -- > No virus found in this outgoing message. > Checked by AVG Free Edition. > Version: 7.1.375 / Virus Database: 267.14.20/234 - Release Date: > 18/01/2006 > > > ** 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 -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.375 / Virus Database: 267.15.2/251 - Release Date: 04/02/2006 -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.375 / Virus Database: 267.15.2/251 - Release Date: 04/02/2006 ** 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