addition error code is 1E+05. What does that mean?

  • Thread starter Thread starter jojosf
  • Start date Start date
J

jojosf

I am adding one cell and a cell from a worksheet within a file and the error
code is 1E=05. Everything else works out but this one cell that is carrying
over. Any thoughts on what this means?
 
What makes you think it is an error code and not just the correct number
shown in scientific notation. Try reformatting the number to a more common
number format...
 
That is not an error, it is just that Excel decided to use Scientific
Format.

Probably due to the length of the number.

Try changing format to "number".


Gord Dibben MS Excel MVP
 
Jojo: As the other said, that's a large number displayed in Scientific
Notation

Right click on the column in which you want to see your numbers formatted
properly, and click on the option "Format Cells..."

On the "Number" tab that pops up, and under "Category", select "Number"
format ... you can then choose to have decimals or not.

This should fix your problem.

Here is essentially the dialog box you are looking for:
http://www.demed.be/images/Excel Format cells.jpg

Hope this helps you :)
--
Best of Luck!,

Chris Van Nuys

Become more effective and efficient: Drive your business career by
mastering Excel!
 
Back
Top