Hi,
Is there a way to force Excel to display the Scientific format of large numbers when the power-digit can be divided only into 5 - such as: E+05, E+10, E-15 and the number itself will be adjusted accordingly.
1.23E+07 will be either: 123E+05 or: 0.00123E+10
What I basically mean is that the: 0.00E+00 will be one of the following:
0.00E+05
0.00E+10
0.00E+15
0.00E-05 etc...
Thanks, Elm
Bookmarks