[access-uk] Re: Excel question
- From: "Catherine Turner" <catherineturner2000@xxxxxxxxxxx>
- To: <access-uk@xxxxxxxxxxxxx>
- Date: Fri, 20 Jan 2006 11:30:01 -0000
Ok, thanks - that explains things more to me.
Still a couple of questions though.
The sheet isn't now blank as it was started by someone else and now I'm
working on it. Is there any way I can now tell it to default to Text?
Also, if I did start from scratch, how do I set the default format?
Sorry for all the extra questions, and thanks everyone for your help.
Catherin
> -----Original Message-----
> From: access-uk@xxxxxxxxxxxxx [mailto:access-uk@xxxxxxxxxxxxx]On Behalf
> Of roger south
> Sent: 19 January 2006 16:47
> To: access-uk@xxxxxxxxxxxxx
> Subject: [access-uk] Re: Excel question
>
>
> Hi Catherine
>
> I must be misunderstanding you here. Excel will only format what
> you want it
> to. All other is default. If you format a range as George
> detailed it will
> do just that. The next cell after the range you quote will be as per
> default. If you want the whole spreadsheet formatted in the text
> format set
> it up as the default while it is blank. If you are not sure how
> many lines
> or columns you want formatted err on the generous side and change them to
> something else at a later stage.
>
> Roger
>
>
> There are more old drunkards than old doctors.
>
> ----- Original Message -----
> From: "Catherine Turner" <catherineturner2000@xxxxxxxxxxx>
> To: <access-uk@xxxxxxxxxxxxx>
> Sent: Thursday, January 19, 2006 2:05 PM
> Subject: [access-uk] Re: Excel question
>
>
> > 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
> >
>
> ** 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: