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?
"Debra Dalgleish" wrote:
> Formatting won't help in this case. The question is about entering data,
> when the Fixed Decimal option in on (Tools>Options, Edit tab)
> John Armenia wrote:
> > you could just change the cell format to the format you want.
> > John
> > "Debra Dalgleish" > wrote in message
> > ...
> >>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
> >>CPAMichael wrote:
> >>>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
> Excel FAQ, Tips & Book List