auto format to decimels

Posted by cutsman on January 23, 2001 5:57 AM

When I enter a number xxxxx, Excel automatically formats it
to xx.xx. I have to enter the number to xxxx.xx to keep
the value I want, even though the formula bar displays
XXXX when I enter xxxx.
thanks

Posted by Dave Hawley on January 23, 2001 6:16 AM

Hi cutsman

Try going to Tools>Options/Edit and make sure the "Fixed decimal places" isn't checked.

Hope that helps
Dave
OzGrid Business Applications