Fixed decimal places

S

Steve Wilson

In Excel 2002 when decimals are fixed at 2 places, and you
enter 1. it will display as 1.00.
In Excel 2003 when decimals are fixed at 2 places, and you
enter 1. it displays .01 (you need to enter 1.0 to get
1.00.

Is there a fix for this; as an accountant entering large
amounts of numbers it will be hard to learn the extra
keystrokes.
 
K

Karlynn

I'm having the same problem as Steve.
I'm not sure what Andy means by format after.
And if I have to type 1.0, then I might as well just type 100, to get
1.00, same amount of strokes.
Anyone have any suggestions/fixes.
Thank you.
 
Top