"Neil Goldwasser" ha scritto nel
messaggio ...
Hi all! Here is a challenge for you...

Does anybody know how to combine worksheet functions to generate the
leading
number from the Standard Index Form version of a "normal number"?

For example,...
...if the input was 340000, the output would be 3.4
...if the input was 0.00278, the output would be 2.78

your number in [A1]
in [B1]
=A1/10^INT(LOG(A1))
or
=TEXT(A1/10^(INT(LOG(A1))),"0.00") & "E" &TEXT(INT(LOG(A1)),"000")
.f