Right ‼ As written in Excel inner help ! …999999999999999 (15 nines) perhaps, due to FP15 preciseness?
Displayed text became:9.99999999999999E+307
And it was right aligned by default (excel treated it as a number).1.00E+308
in another cell then the entry became left aligned (excel treated it as text)1.00E+308
So Excel is showing some strange phenomenon at the specification limit as it can then be argued that the largest possible number that can displayed in Excel is in the range of 1.80E+308.1.80E+308
Acutally... MS documentation has a lot of mistakes, especially in non-English versions.Which one would know better
... Microsoft itself or someone else?
1.79769313486231E+308
1.7976931348623158e+308
1.79769313486232E+308
Hi Lori,The point of questions like this is really just to raise an interesting and lively discussion as well as hopefully learn something new!
[A1]=1.7976931348623158e+308
?[A1].Value(11)