How do I override fixed decimal place settings in EXcel 2003?

[Guest]

How do I override fixed decimal place settings in EXcel 2003? The override
function does not work (pressing the decimal key after enterung the number in
a cell.)

 

[Debra Dalgleish]

You can add a decimal and a zero at the end of the number, to override
the fixed decimals. For example, type 33.0 and it well be entered as 33

 

[John Armenia]

you could just change the cell format to the format you want.

John

 

[Ragdyer]

I don't have this problem.
Did Redmond change this for '03 Debra?

 

[Frank Kabel]

Hi RD
yes, Excel 2003 is different than the previous versions for this

 

[Ragdyer]

So you mean that someone actually thought that this was an improvement ?!?!?

Thanks Frank.

 

[Debra Dalgleish]

Formatting won't help in this case. The question is about entering data,
when the Fixed Decimal option in on (Tools>Options, Edit tab)

 

[Guest]

Well thank you. I thought it wa me and I wias misssing something. I guess I
will reinstall Excel 2002 So I can actually save time by using the program.

 

[Guest]

What improvement how do I get them to put back to the way it was.

 

[Frank Kabel]

Hi
no chance to get it back ;-)

 

[Guest]

I have just upgraded an entire Tax/Accounting office to Excel 2003, and they
are very unhappy about this little change.

With fixed decimal set to 2 places:
In office 2000 when you entered 20. you got 20.00
In office 2003 when you entered 20. you get .20
In office 2003 when you entered 20.0 you get 20.00

It may not seem like much but when you do thousands entries a day an extra
key stroke on half of them is a big deal.

Any chance this will be fixed?

 

[Dave Peterson]

My guess is that MS won't change this behavior in any existing version.

But you could write to them expressing your concern for a future version:

(e-mail address removed)
(e-mail address removed)

(include excel in the subject so that it gets to the correct group.)

 

[Guest]

Sorry I cannot help. I just want to add my disgust at this "upgrade." As an
accountant the problem gets worse when you click into a cell and then leave
that cell and 20 turns into .20. Try explaining that to a client.