[access-uk] Re: Excel question
- From: "Catherine Turner" <catherineturner2000@xxxxxxxxxxx>
- To: <access-uk@xxxxxxxxxxxxx>
- Date: Sun, 5 Feb 2006 17:11:01 -0000
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
Other related posts:
