Changing Number Formats based upon value
 

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

Changing Number Formats based upon value
 

On Wed, 14 May 2008 07:15:01 -0700, DaveyC
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

Changing Number Formats based upon value
 

Ron, that's great. Thank you.

"Ron Rosenfeld" wrote:

On Wed, 14 May 2008 07:15:01 -0700, DaveyC
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

Changing Number Formats based upon value
 

On Wed, 14 May 2008 08:01:01 -0700, DaveyC
wrote:

Ron, that's great. Thank you.

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