Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hide Negative Numbers or Display as Zero
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hide Negative Numbers or Display as Zero
Try this:
=IF(D10="","",IF(ISTEXT(C10),D10,D10-C10)*24) will display a blank if D10 is blank. Hope this helps. Pete On Oct 24, 1:34 am, 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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hide Negative Numbers or Display as Zero
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? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hide Negative Numbers or Display as Zero
Nope, didn't work. I even tried this formula:
=IF(D10<0,0,IF(ISTEXT(C10),D10,D10-C10))*24 and still doesn't work. If I can't figure it out I'll just use conditional formatting and set font and background as white unless it's over 0. Thanks for the response! "Pete_UK" wrote: Try this: =IF(D10="","",IF(ISTEXT(C10),D10,D10-C10)*24) will display a blank if D10 is blank. Hope this helps. Pete On Oct 24, 1:34 am, 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? |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hide Negative Numbers or Display as Zero
Try this :
=IF(D10=0,"",IF(ISTEXT(C10),D10,D10-C10)*24) "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? |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hide Negative Numbers or Display as Zero
Try this :
=IF(D10=0,"",IF(ISTEXT(C10),D10,D10-C10)*24) HTH "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? |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hide Negative Numbers or Display as Zero
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? |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I display negative numbers as zeros? | Excel Discussion (Misc queries) | |||
how to display mainframe negative numbers on excel | Excel Worksheet Functions | |||
display negative numbers as zero | Excel Discussion (Misc queries) | |||
Hide negative numbers in Excel | Excel Discussion (Misc queries) | |||
How do I display negative numbers in a differnt color font? | Excel Discussion (Misc queries) |