Ok here is the problem;
I have a column that displays a date if no date exists
then a zero is placed in it. What I am trying to do is to clear (display
blank cell) that have a value of zero (0) but keep the date in all cells that
have a date. (I am aware of the fomula being in the blank cell but I already
know how to fix that by the paste special function)

I think the IF Function could do it, but when I've used suggested formulas
off this web page none seem to work. When I used this formula =IF(0,null,"")
then paste it to all cells, it removes all dates.



Any help would be appreciated

Thx