Excel divides number by 10e6 unless followed by decimal point.

J

JohnO

Excel divides any number I enter into a cell by 1,000,000 unless the number
is followed by a decimal point. I enter "1", and the cell displays
".000001", enter "1.", and the cell displays "1". What can I do to correct
this? It doesn't matter if I use a workbook created years ago, or a new on
created today.
 

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

Top