You need to tick the match entire cell contents on the find and replace.
1. CTRL +F
2. Find what = 0
3. Replace with = leave blank
4. tick match entire cell contents

This should work

Thanks
Matt





Evil with a K wrote:
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

--
Matt Lynn

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200905/1