Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Custom "conditional" format ?
I find Excel does a pretty good job of hiding the help for custom cell
formats. I found part of it, but I was unable to find the help for when you want the format to vary depending on the cell value. I tried this: [=100]#,##0;[<100]0.000;;"-" Except when the value is zero I get 0.000, which means the ending of the above isn't working. So how do I get no decimals when 100, three decimals when less, and a dash when 0? Don <www.donwiss.com (e-mail link at home page bottom). |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Custom "conditional" format ?
One way:
[=100]#,##0;[0]0.000;"-"; Note that values <0 will also get the "-", since XL can only have 3 numeric ranges in a custom format. At least in XL04, the "About custom number formats" Help topic is pretty complete. In article , Don Wiss wrote: I find Excel does a pretty good job of hiding the help for custom cell formats. I found part of it, but I was unable to find the help for when you want the format to vary depending on the cell value. I tried this: [=100]#,##0;[<100]0.000;;"-" Except when the value is zero I get 0.000, which means the ending of the above isn't working. So how do I get no decimals when 100, three decimals when less, and a dash when 0? Don <www.donwiss.com (e-mail link at home page bottom). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom number format thousands and zeros as "-" | Excel Discussion (Misc queries) | |||
retain custom date format "text" when pasting or reformatting data | Excel Discussion (Misc queries) | |||
In Excel 2007, can you add "custom" formats to number format dropd | Setting up and Configuration of Excel | |||
Custom Format font for "xx" to yellow | Excel Discussion (Misc queries) | |||
Custom date format shows "051117.Thu" for today. Way to have "051117.Th", instead? | Excel Programming |