Keeping the exponent at a fix value in Excel

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

On Sat, 07 Jan 2006 17:49:01 GMT, "WayneL"
<[email protected]> wrote:

>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
>

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 Voice480)460-2350 | |
| E-mail Address at Website Fax480)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



"WayneL" <[email protected]> wrote in message
news:[email protected]...
> 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

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" <[email protected]> wrote in
message news:[email protected]...
> On Sat, 07 Jan 2006 17:49:01 GMT, "WayneL"
> <[email protected]> wrote:
>
>>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
>>
>
> 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 Voice480)460-2350 | |
> | E-mail Address at Website Fax480)460-2142 | Brass Rat |
> | http://www.analog-innovations.com | 1962 |
>
> I love to cook with wine. Sometimes I even put it in the food.

On Sat, 07 Jan 2006 18:21:21 GMT, "WayneL"
<[email protected]> wrote:

>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

[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 Voice480)460-2350 | |
| E-mail Address at Website Fax480)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