You'd think so but it is a microsoft product when all's said and done LOL
Trace
Yeah, I see what you mean. And will do that - but I just thought there'd be
some way of telling Excel "Make everything in this column x format
regardless of how many more lines I add" - so without selecting loads of
cells.
Catherine
-----Original Message----- From: access-uk@xxxxxxxxxxxxx [mailto:access-uk@xxxxxxxxxxxxx]On Behalf Of Spring Flower Sent: 19 January 2006 18:52 To: access-uk@xxxxxxxxxxxxx Subject: [access-uk] Re: Excel question
I'm reading this lot backwards but, you are selecting the cells you want to format first?
For example, when I was doing a sheet last week to list my DVD's I put the highlighted cell as the very first and top one and then cursored down a few hundred lines and across a few columns so I had loads and loads of cells selected that would be altered when I formatted.
Trace
----- Original Message ----- From: "Catherine Turner" <catherineturner2000@xxxxxxxxxxx> To: <access-uk@xxxxxxxxxxxxx> Sent: Thursday, January 19, 2006 3:51 PM Subject: [access-uk] Re: Excel question
> Hi Patricia,
>
> For some reason I still can't get into the Format/Cells dialog
- have made
> sure I definitely finished the edit first.
>
> 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?
>
> Catherine
>
>> -----Original Message-----
>> From: access-uk@xxxxxxxxxxxxx [mailto:access-uk@xxxxxxxxxxxxx]On >> Behalf
>> Of Patricia Fraser
>> Sent: 19 January 2006 13:29
>> To: access-uk@xxxxxxxxxxxxx
>> Subject: [access-uk] Re: Excel question
>>
>>
>> Hi Catherine,
>>
>> Additional to George's reply:
>>
>> > 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?
>>
>> In this case, I'd say that you are still editing the cell -
>> you need to press Enter to complete the edit before you go
>> to the Format menu. Your cursor will have moved as a result,
>> so you'll need to go back to the correct column or row
>> before formatting. The representation you're hearing is the
>> scientific or exponential notation.
>>
>> Hope this helps,
>>
>> --
>> 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
>>
>
>
> ** 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
>
>
>
> --
> Internal Virus Database is out-of-date.
> Checked by AVG Free Edition.
> Version: 7.1.371 / Virus Database: 267.13.13/199 - Release Date:
> 13/12/2005
>
** 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
--
Internal Virus Database is out-of-date.
Checked by AVG Free Edition.
Version: 7.1.371 / Virus Database: 267.13.13/199 - Release Date: 13/12/2005
** 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