| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
custom format cell, if value is 0, then write "-"
Hi all,
How can I custom a cell of hours so that 10 is 10 and 9.5 is 9.5. If value is 0 then it'll write '-' in the cell Thanks in advance! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
custom format cell, if value is 0, then write "-"
General;General;_-* "-"??_-;_-@_-
-- HTH Bob Phillips (remove nothere from email address if mailing direct) "Toto Sanderson" wrote in message ... Hi all, How can I custom a cell of hours so that 10 is 10 and 9.5 is 9.5. If value is 0 then it'll write '-' in the cell Thanks in advance! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
custom format cell, if value is 0, then write "-"
Great! Thanks!
"Bob Phillips" wrote: General;General;_-* "-"??_-;_-@_- -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Toto Sanderson" wrote in message ... Hi all, How can I custom a cell of hours so that 10 is 10 and 9.5 is 9.5. If value is 0 then it'll write '-' in the cell Thanks in advance! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I write an excel formula with a text answer ("yes" or "no") | Excel Discussion (Misc queries) | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| custom format cell, if value is 0, then write "-" | Excel Discussion (Misc queries) | |||
| Custom date format shows "051117.Thu" for today. Way to have "051117.Th", instead? | Excel Programming | |||
| Using "Cells" to write "Range("A:A,H:H").Select" | Excel Programming | |||
![Toto Sanderson[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
