Changing Number Formats based upon value

D

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
 
R

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
Click to expand...

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
 
D

DaveyC

Ron, that's great. Thank you.

Ron Rosenfeld said:
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
Click to expand...

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
Click to expand...
 
Top