[access-uk] Re: Excel question
- From: "Carol Pearson" <carol.pearson@xxxxxxxxxxxx>
- To: <access-uk@xxxxxxxxxxxxx>
- Date: Wed, 8 Feb 2006 10:46:37 -0000
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
Other related posts:
