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:
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
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
-- "it\'s the network..." "The Journey is the reward" speff@interlog.com Info for manufacturers: http://www.trexon.com Embedded software/hardware/analog Info for designers: http://www.speff.com
Speaking of which: Does Excel do SI prefixes yet?
Jeroen Belleman
ElectronDepot website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.