[access-uk] Re: Excel question
- From: "Patricia Fraser" <trish@xxxxxxxxxxxxxxxxxxx>
- To: <access-uk@xxxxxxxxxxxxx>
- Date: Thu, 19 Jan 2006 16:58:27 -0000
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:
