Formatting of cells

P

Pete

All new and old spreadsheets now have a bug. Any typed number (say 5) comes
out as .05 every time. help! Normal change of format using Format / Cell/
Number does not work!
 
B

Bob Phillips

Menu Tools>Options and go to the Edit tab.

See if the Fixed Decimal box is checked, if so uncheck it.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
Top