Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Getting rid of all negative numbers on a worksheet
Ok, for the workbook i'm building, I need all numbers equal to or less
than 0 to *not* be displayed. Instead I want the cells to be left blank or display: -- (i'd prefer if the cells were blank though). The real problem is that I have a range of cells that have the formula =DAYS360 in them. That formula counts the days between two dates on the worksheet, but when one date is entered and the other isn't, the cell displays a huge negative number( becuase of the dept. i work in, i never know the second date until sometime later, but the sheet still has to be printed up in the meantime). I've tried everything I could think of to fix it or get around this problem, but nothing quite works, then, I realized "well, if I could just get the worksheet to display a blank cell anytime a cell value is 0 or less, then the problem wouldn't exist" thanks --- Message posted from http://www.ExcelForum.com/ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert to negative numbers in whole worksheet | Excel Discussion (Misc queries) | |||
Excel, change column of negative numbers to positive numbers? | New Users to Excel | |||
Excel 2002 : Convert Positive Numbers to Negative Numbers ? | Excel Discussion (Misc queries) | |||
Set negative numbers to zero. Do not calculate with negative valu | Excel Discussion (Misc queries) | |||
change 2000 cells (negative numbers) into positive numbers | Excel Worksheet Functions |