Number Formatting

[HikerBrian]

Hello,

I have a list of numbers ranging from .00005 to 50. I'd like to format them in engineering notation, which is scientific notation always using E-3. This means the numbers would be displayed as:

0.05E-3
0.5E-3
5.0E-3
50E-3
500E-3
5,000E-3
50,000E-3

Additional leading or trailing zeros are ok, but not desired.
Thanks!

 

[Rick Rothstein]

Actually, engineering notation does not alway use E-3 as the exponent... it just requires the absolute value of the exponent to be the largest whole number exactly divisible by 3. That is a paraphrase of how it is described here...

http://en.wikipedia.org/wiki/Engineering_notation

So what do you want... what you asked for or true engineering notation?

 

[HikerBrian]

I'd like true engineering notation, but if that's not possible I'll settle for using E-3 for everything.