Cell changes from General format to Scientific
123E306=1.23E+308 is larger than the maximum value allowed
flish wrote:
But when I entered 123E306 in a cell having the format of General. It returns
123E306 and retains the General formatting. It doesn't convert it to
scientific format
"Lori" wrote:
Excel only allows values less than 1E+308.
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
|