Replace single 0 without affecting other cells

[Cindy E]

Is there a way to replace cells with just a 0, but not affect other cells. I
exporting data with tons of columns, including phone numbers, fax, etc. In
the cells that don't have a real phone number, etc., it imported as a single
0. I would rather not have to filter every column to delete these.

Thanks.

 

[Tom Hutchins]

Select all the columns where you want to replace the zeros. The select Editfield empty. Click the 'Options >>' button and put a check in the 'Match
entire cell contents' box. Then click 'Replace all'.

Hope this helps,

Hutch