[access-uk] Re: Excel question

Hi Catherine,

The quick and dirty way to sort this is when you are
entering the telephone number.  Precede it with a single
quote, which will tell Excel to display it exactly as input.

Otherwise you can format the cell, or cells, and select the
format you want.

In this case, highlight the column of telephone numbers.

From the Format menu, select "Cell".

Make sure you are on the "Number" tab.  Go down the Category
list and select "Text".  Press O.K.

George.

-----Original Message-----
From: access-uk@xxxxxxxxxxxxx
[mailto:access-uk@xxxxxxxxxxxxx] On Behalf Of Catherine
Turner
Sent: 19 January 2006 12:43
To: Access-UK
Subject: [access-uk] Excel question

Hello all,

In an Excel sheet I want one column to be for people's phone
numbers.  So far I've just put 1 phone number in, I wrote
08453978193.  But when I cursor to it with JAWS it really
sounds like JAWS is saying "Eighty plus zero
nine".   But if I press F2 to edit it the only wrong thing
is that the 0 is
missing from the beginning.

So a couple of questions:

1.  How can I make it keep the 0 at the beginning?  I
thought this would be something to do with format.  But when
I went into the Format menu and pressed Enter on Cells, no
dialog appears and nothing seems to happen.  Why is this?

2.  When I cursor to the cell why is JAWS saying "Eighty
plus zero nine"?

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

** 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: