Engineering Notation

[Fred_Piering]

I would like to format the numbersso they are always in "Engineering" notation. that is always a group of three, like the HP calculators do. that way we can work and display as uF, nF, pF., etc.

10-3. 10-6, 10-12, etc.

[#2 · Accepted solution]

@Fred_Piering 

The nearest Excel comes (I think) is the custom number format

##0E+0

or

##0.000E+0

[#3]

That worked!

Thanks You.

Fred

@HansVogelaar 

[#4]

@HansVogelaar 

That is perfect.  I tend to use

##0.000E+00