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!

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

General;-General;-

"Toto Sanderson" wrote:

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!

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

See answer in .programming

--
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!

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

Try a custom format of:

General;General;'-'


--
Cutter
------------------------------------------------------------------------
Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848
View this thread: http://www.excelforum.com/showthread...hreadid=516185

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

Thanks! It works!

"Sloth" wrote:

General;-General;-

"Toto Sanderson" wrote:

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!