Changing Number Formats based upon value

[DaveyC]

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

 

[Ron Rosenfeld]

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

 

[DaveyC]

Ron, that's great. Thank you.

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

Ron, that's great. Thank you.

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