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?