software

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

quot;Toto Sandersonquot; wrote:

gt; Hi all,
gt;
gt; How can I custom a cell of hours so that 10 is 10 and 9.5 is 9.5. If value
gt; is 0 then it'll write '-' in the cell
gt;
gt; Thanks in advance!
gt;

See answer in .programming

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;Toto Sandersonquot; gt; wrote in message
...
gt; Hi all,
gt;
gt; How can I custom a cell of hours so that 10 is 10 and 9.5 is 9.5. If value
gt; is 0 then it'll write '-' in the cell
gt;
gt; Thanks in advance!
gt;

Try a custom format of:

General;General;'-'--
Cutter
------------------------------------------------------------------------
Cutter's Profile: www.excelforum.com/member.php...foamp;userid=9848
View this thread: www.excelforum.com/showthread...hreadid=516185Thanks! It works!

quot;Slothquot; wrote:

gt; General;-General;-
gt;
gt; quot;Toto Sandersonquot; wrote:
gt;
gt; gt; Hi all,
gt; gt;
gt; gt; How can I custom a cell of hours so that 10 is 10 and 9.5 is 9.5. If value
gt; gt; is 0 then it'll write '-' in the cell
gt; gt;
gt; gt; Thanks in advance!
gt; gt;