Engineering notation

[JoeB]

Anyone know how to format a cell to display in the closest engineering
notaion, and to 2 decimal places:

for example:

10010 => 10.01e-3
1230000 => 1.23e6
1.23e-11 => 12.30e-12




TIA



Joe

 

[Kevin H. Stecyk]

Hi Joe B,

Have a look here: http://tinyurl.com/58ga9

Hope that helps.

Kevin

 

[JE McGimpsey]

Try:

Format/Cells/Number/Custom ##0.00e+0

 

[JoeB]

thanks all -- what a super fast responce!