Hide Negative Numbers or Display as Zero
No need for the quotations for blanks
0;
will do
--
Regards,
Peo Sjoblom
"ilia" wrote in message
oups.com...
Do you need to use the zero in calculations? If not, use this number
format to display zero:
0;"0"
or this number format to display blank:
0;""
On Oct 23, 8:34 pm, Me wrote:
I'm using Excel 2007 and can't figure out how to hide Negative Numbers or
dispay them as Zero. I'm making a timesheet and this is the formula I'm
using: =IF(ISTEXT(C10),D10,D10-C10)*24. When C10 is not text and I enter
8:00, F10 shows as -8.00. How can I hide this or display it as Zero until
I
enter a value in D10?
|