On Jan 19, 1:15*pm, Bernd P wrote:
=--TEXT(A1,"0.00E+0")

Yes. Getting your point moments after pressing Submit and leaving for
the gym, I realized that would work. Klunk! But arguably, my
original solution is better for anyone who gets paid by the character
<g.