[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

Other related posts: