Posted to microsoft.public.excel.misc

DaveyC

external usenet poster

Posts: 7

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
changing date formats	Heine	Excel Worksheet Functions	4	May 3rd 07 03:54 PM
sorting without changing formats	LisaD	Excel Worksheet Functions	4	April 4th 07 10:59 PM
Changing number formats without rebuilding worksheet	Joe	Excel Discussion (Misc queries)	2	January 17th 07 04:54 PM
Changing date formats?	lakegoddess	Excel Discussion (Misc queries)	5	January 6th 06 05:26 PM
Changing chart color based on number entered	confused chart girl	Charts and Charting in Excel	0	October 27th 05 05:26 PM

All times are GMT +1. The time now is 02:59 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us