Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
specify a certain cell format as part of an "if" statement
How do I specify a specific cell format (e.g., scientific) as part of an if
statement? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
specify a certain cell format as part of an "if" statement
You don't, unless you want to use the TEXT() function.
-- David Biddulph Zeev Maoz wrote: How do I specify a specific cell format (e.g., scientific) as part of an if statement? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
specify a certain cell format as part of an "if" statement
Are you wanting to write VBA code (macro) to do that or did you want to do
this without code. The short answer is that it can not be done without code. The closest you get is conditional formats which can modify cell formats, but number formats are not included in the list of attributes accessable via conditional formatting. -- HTH... Jim Thomlinson "Zeev Maoz" wrote: How do I specify a specific cell format (e.g., scientific) as part of an if statement? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Format a cell such that "#NAME?" reads/appears "N/A"? | Excel Discussion (Misc queries) | |||
If part of a cell = "NVA" then insert "Norfolk" in return cell | Excel Worksheet Functions | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
Format cell to display "Y" or "N"when entering a 1 or zero | Excel Discussion (Misc queries) | |||
How do I reference a cell as PART of a vlookup "Table_Array" locat | Excel Worksheet Functions |