Very strange values??

  • Thread starter Thread starter Ed from AZ
  • Start date Start date
E

Ed from AZ

My column is formatted ##0.00. So why do I have values like:
1.66666656732559e-002
1.66666656732559e-002
1.66666656732559e-002
3.33333313465118e-002
9.99999940395355e-002
3.33333313465118e-002
9.99999940395355e-002

Ed
 
If you really see that lower case e/E, then your values in the cells aren't
numeric. They're text.

You may be able to convert them to real values by:
selecting an empty cell
edit|Copy
select the offending range
edit|paste special|click Add and Values

And then reapply the number format if you need to.
 
Back
Top