[access-uk] Re: Excel question
- From: "Catherine Turner" <catherineturner2000@xxxxxxxxxxx>
- To: <access-uk@xxxxxxxxxxxxx>
- Date: Thu, 19 Jan 2006 14:05:49 -0000
Thanks George.
Another question though - should I be able to get into the Format/Cells
dialog when just focused in one cell from that column? Because when in cell
J1, which says in it "Phone No", pressing Enter on Format/Cells does
nothing. So I selected the entire column, then followed the steps below -
which has worked. But the problem is, if I add more data below the point I
selected to, the problem with the numbers being miswritten/misread by JAWS
reoccurs. Does this mean every time I add another row of data I have to
format the cells again? I think I must be missing something...?
Catherine
> -----Original Message-----
> From: access-uk@xxxxxxxxxxxxx [mailto:access-uk@xxxxxxxxxxxxx]On Behalf
> Of George Bell
> Sent: 19 January 2006 13:15
> To: access-uk@xxxxxxxxxxxxx
> Subject: [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
>
** 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: