View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Me Me is offline
external usenet poster
 
Posts: 67
Default Hide Negative Numbers or Display as Zero

I thought of that but I was hoping there was a formula or option I could set
such as hiding zero values. If all else fails this is what I'll do. Thanks!

"Gary''s Student" wrote:

Don't know if this applies to 2007, but try condtional formatting, with value
less than or equal to zero:

Set the font color equal to the background color.
--
Gary''s Student - gsnu200750


"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?