On Sun, 9 Dec 2007 09:10:54 -0800 (PST), joeu2004 wrote:

On Dec 9, 7:46 am, Ron Rosenfeld wrote:
=LEFT(TEXT(ABS(A1),"0.0"& REPT("0",50)&"E+0"),1)

It does not make sense to have more than 14 zeros after the decimal
places in Scientific notation format -- i.e. REPT("0",13) in your
formula. Beyond than, Excel simply displays zeros. For example,
consider the value 1/3. Mathemathically, we know that is a fraction
of repeating 3s. In the 64-bit IEEE 754 binary representation, it is
exactly 0.333333333333333314829616256247390992939472198486 328125. But
in Excel Scientific notation format with 18 decimal places, it is
displayed as 3.333333333333330000E-01, not 3.333333333333333148E-01.
Increasing the number of decimal places simply increases the number of
appended zeros.

I should have written, "... just put in a 13, as you did in an earlier post
that I missed".


--ron