View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Chris Van Nuys Chris Van Nuys is offline
external usenet poster
 
Posts: 4
Default addition error code is 1E+05. What does that mean?

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%20Format%20cells.jpg

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

Chris Van Nuys

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


"jojosf" wrote:

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?