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