Engineering Notation

 

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

 

 
 


 

 

 

Description: Description: ufopanelReturn to Tips and Tricks Index