Hi

Is it possible to change the format of a number from a general status to a
scientific one based upon its value. For example if the value exceeds 100000
the value display would change to 1.00E+05

I am using Excel 2003.

Any help greatly appreciated.
Many thanks
Dave

On Wed, 14 May 2008 07:15:01 -0700, DaveyC <(E-Mail Removed)>
wrote:

>Hi
>
>Is it possible to change the format of a number from a general status to a
>scientific one based upon its value. For example if the value exceeds 100000
>the value display would change to 1.00E+05
>
>I am using Excel 2003.
>
>Any help greatly appreciated.
>Many thanks
>Dave

Your request is clear but I'm not sure you mean what you wrote.

To provide just what you request, format the cell as:

(Format/Cells/Number/Custom Type: )

[>100000]"1.00E+05";General

However, if what you "mean" is that you want the actual value displayed in
Scientific format similar to your example, then format the cells as:

[>100000]0.00E+00;General

And, furthermore, if what you really mean is that you want values *equal* to or
greater than 100000 as above, then change the condition part to:

[>=100000]

--ron

Ron, that's great. Thank you.

"Ron Rosenfeld" wrote:

> On Wed, 14 May 2008 07:15:01 -0700, DaveyC <(E-Mail Removed)>
> wrote:
>
> >Hi
> >
> >Is it possible to change the format of a number from a general status to a
> >scientific one based upon its value. For example if the value exceeds 100000
> >the value display would change to 1.00E+05
> >
> >I am using Excel 2003.
> >
> >Any help greatly appreciated.
> >Many thanks
> >Dave
>
> Your request is clear but I'm not sure you mean what you wrote.
>
> To provide just what you request, format the cell as:
>
> (Format/Cells/Number/Custom Type: )
>
> [>100000]"1.00E+05";General
>
> However, if what you "mean" is that you want the actual value displayed in
> Scientific format similar to your example, then format the cells as:
>
> [>100000]0.00E+00;General
>
> And, furthermore, if what you really mean is that you want values *equal* to or
> greater than 100000 as above, then change the condition part to:
>
> [>=100000]
>
> --ron
>

On Wed, 14 May 2008 08:01:01 -0700, DaveyC <(E-Mail Removed)>
wrote:

>Ron, that's great. Thank you.

You're welcome. Glad to help.
--ron