Difference between ExcelXP and Excel 2003

G

Guest

In Excel XP, when entering a number on a worksheet, I was able to enter the
decimal at the end of a number and excel would fill in the required number of
spaces after the decimal with zeros. I can not get Excel 2003 to do that and
to also place the decimal properly as formatted. "ie", enter 50. to get 50.00
and 555 to get 5.55 with out entering the decimal.
 
G

garfield-n-odie

In Excel, click on Tools | Options | Edit | check the "Fixed decimal
places" box and set the number of decimal places to 2 | OK.
 
G

Gord Dibben

Wesley

This appears to be an inadvertent change to the "fixed decimals" in XL2003.

See this thread from a google search.

Ignore my contribution to that thread<g>.


http://snipurl.com/6i4k

Gord Dibben Excel MVP
 

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

problem with number format with 2 decimals? 5
Problem entering numbers 3
Setting formatting for 2 places 3
Decimal point in general format 1
excel 2003 zero as last decimal 5
Excel Excel 2007 won't stop rounding down my formula results! 5
Decimal point will not hold 2 places in Excel 2003 3
Data validation with a fixed amount of decimal places 9

Top