ExcelBanter - custom format cell, if value is 0, then write "-"

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - custom format cell, if value is 0, then write "-" (https://www.excelbanter.com/excel-programming/354290-custom-format-cell-if-value-0-then-write.html)

Toto Sanderson[_2_]

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!

Bob Phillips[_6_]

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!

Toto Sanderson[_2_]

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!

All times are GMT +1. The time now is 06:38 PM.