SOLVED

Engineering Notation

Copper Contributor

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.

3 Replies
best response confirmed by Peter Bartholomew (Silver Contributor)
Solution

@Fred_Piering 

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

 

##0E+0

or

##0.000E+0

That worked!

Thanks You.

Fred

@Hans Vogelaar 

@Hans Vogelaar 

That is perfect.  I tend to use

##0.000E+00

1 best response

Accepted Solutions
best response confirmed by Peter Bartholomew (Silver Contributor)
Solution

@Fred_Piering 

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

 

##0E+0

or

##0.000E+0

View solution in original post