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?

The error code 1E+05 in Excel usually means that the result of your calculation is too large to be displayed in the cell. In other words, the number is too big for the cell to handle.

To fix this issue, you can try increasing the width of the cell or changing the format of the cell to scientific notation. Here's how you can do it:

1. Select the cell that is displaying the error code.
2. Right-click on the cell and select "Format Cells".
3. In the Format Cells dialog box, select the "Number" tab.
4. Under "Category", select "Scientific".
5. In the "Decimal places" field, enter the number of decimal places you want to display.
6. Click "OK" to apply the changes.

If changing the format of the cell doesn't work, you can try breaking down the calculation into smaller parts and then adding them together. This can help to avoid the error code and give you the correct result.

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...
--
HTH...

Jim Thomlinson


"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?

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

On Fri, 5 Sep 2008 14:56:19 -0700, 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?

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?