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
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 | |
[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 | |
Hi
When formatting in Scientific, how can you keep the exponent constant and allow the decimal point to move? For example
If I have:
How do I ensure that Excel keeps the E to E-3 and adjust the decimal point?
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 "Jim Thompson" wrote in message news: snipped-for-privacy@4ax.com...
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
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-02How do I ensure that Excel keeps the E to E-3 and adjust the decimal point?
Cheers
WayneL
Like this: ###.000E+00
Best regards, Spehro Pefhany
Speaking of which: Does Excel do SI prefixes yet?
Jeroen Belleman
Have something to add? Share your thoughts — no account required.
Ask the community — no account required