General Number Format

  • Thread starter Thread starter johnerr
  • Start date Start date
J

johnerr

Folks,

I have a problem with the format of the numbers in my spreadsheet.
Every number seems to be dividing itself by 1000.

eg. if i put 4 into a cell, it changes itself to 0.004. I have checked
to format of the general number and it is set to 0.001 as its example.
HOw can I get this back to normal?

Any help???
 
Check Tools>Options>Edit and see if the Fixed decimal box is checked, if so,
uncheck it.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Back
Top