| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| changing date formats | Excel Worksheet Functions | |||
| sorting without changing formats | Excel Worksheet Functions | |||
| Changing number formats without rebuilding worksheet | Excel Discussion (Misc queries) | |||
| Changing date formats? | Excel Discussion (Misc queries) | |||
| Changing chart color based on number entered | Charts and Charting in Excel | |||
Linear Mode
