Cell changes from General format to Scientific
Your number is outside the range that Excel can handle, so it is
treated as text, even if it doesn't change the cell formatting to text.
Pete
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
|