Keeping the exponent at a fix value in Excel

  • Thread starter Thread starter WayneL
  • Start date Start date
W

WayneL

Hi

When formatting in Scientific, how can you keep the exponent constant and
allow the decimal point to move?
For example

If I have:
6.647E-03
1.741E-02
8.378E-02

How do I ensure that Excel keeps the E to E-3 and adjust the decimal point?

Cheers


WayneL
 
Hi

When formatting in Scientific, how can you keep the exponent constant and
allow the decimal point to move?
For example

If I have:
6.647E-03
1.741E-02
8.378E-02

How do I ensure that Excel keeps the E to E-3 and adjust the decimal point?

Cheers


WayneL
Click to expand...

Don't use "Scientific", use "Engineering" notation.

...Jim Thompson
--
| James E.Thompson, P.E. | mens |
| Analog Innovations, Inc. | et |
| Analog/Mixed-Signal ASIC's and Discrete Systems | manus |
| Phoenix, Arizona Voice:(480)460-2350 | |
| E-mail Address at Website Fax:(480)460-2142 | Brass Rat |
| http://www.analog-innovations.com | 1962 |

I love to cook with wine. Sometimes I even put it in the food.
 
I can't guarantee that it will always be to the -3, but I can guarantee that
it will be an "engineering" prefix that is some multiple of 3 (i.e. kilo,
micro, pico, giga, etc.)

Format the cell(s) in question with the Custom format of ##0.0E+0 (this is
one of the predefined Custom formats).

It wasn't my original idea; I think Jim Thompson showed me how to do it a
few years ago.

Jim
 
Could please let me know how to format in Engineering notation?
I have been in Format => Cell and there is not Engineering on Scientific.

Cheers

WayneL
 
Could please let me know how to format in Engineering notation?
I have been in Format => Cell and there is not Engineering on Scientific.

Cheers

WayneL
Click to expand...

[snip]

Format -> Cells -> Number -> Custom

##0.0E+0

As Jim of RST reminded me.

...Jim Thompson
--
| James E.Thompson, P.E. | mens |
| Analog Innovations, Inc. | et |
| Analog/Mixed-Signal ASIC's and Discrete Systems | manus |
| Phoenix, Arizona Voice:(480)460-2350 | |
| E-mail Address at Website Fax:(480)460-2142 | Brass Rat |
| http://www.analog-innovations.com | 1962 |

I love to cook with wine. Sometimes I even put it in the food.
 
Please let me know how to format in Engineering notation?
I have been in Format => Cell and there is not Engineering on
Scientific.

Cheers

WayneL
 
Please let me know how to format in Engineering notation?
I have been in Format => Cell and there is not Engineering on
Scientific.

Cheers

WayneL
 
Back
Top