Engineers
like to display numbers with the exponent as a power of three.
This can be
done with a custom format such as ##0.00E+0 or ##0.0E+0 but this gives poor
results with number less than 1,000.
This custom
format works better: [<0.01]##0.00E+0;[<1000]
#0.00;##0.00E+0
Return to Tips and Tricks
Index