[access-uk] Re: Excel question

  • From: "roger south" <roger.south@xxxxxxxxxx>
  • To: <access-uk@xxxxxxxxxxxxx>
  • Date: Thu, 19 Jan 2006 16:47:18 -0000

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

Other related posts:

  1. Home
  2. access-uk
  3. Archive
  4. 01-2006