the largest number which can be entered in a cell is just under 1.8E308
your 123E306 is handled as text not a number

"flish" wrote:

Entered 123E305 in a cell having the format of General. It returns 1.23E+307
and changes the cell format to Scientfic.

Entered 123E306 in a cell having the format of General. It returns 123E306
and retains the General formatting.

What would cause this?

Thanks