Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

You cannot hide E from Formatcode because it triggers the split into factor and Exponent.

Maybe calculate Text output with Formula:

=x/10^INT(LOG10(x)) & " * 10^" & INT(LOG10(x))

replace x by the Number respective the Celladdress of the Number