| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel - cell format switches to custom when switching language | Excel Discussion (Misc queries) | |||
| Cell data format | Excel Discussion (Misc queries) | |||
| Format a cell with a custom number format | Excel Worksheet Functions | |||
| Why does Custom Format not control Cell Display? | Excel Discussion (Misc queries) | |||
| How can I write an if-then formula for 0 or less than 0 in cell t. | Excel Worksheet Functions | |||
Threaded Mode
