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)
 

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

Back
Top