Fixed decimal places

  • Thread starter Thread starter Steve Wilson
  • Start date Start date
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.
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

FIXED 2 DECIMAL PLACES, MUST ENTER ALL ZEROES AFTER DECIMAL POINT. 3
Automaticallychanging the number of decimal places displayed 5
Fixed decimal places in Excel 4
Access stripping decimal places in query 1
Fixed Decimals in Excel 2007 4
tiny discrepancies in fixed-point numbers 3
decimal places 2
Help with fixed decimal 4

Back
Top