Worked. thanks
Is there a reason why the Find and Replace didn't work with currency format?

L.

"Sandy Mann" wrote in message
...
Format the cells as Accounting

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"L.S." wrote in message
...
Have a spreadsheet with "several" 0.00 in cells.

Tried -- Find 0.00 and Replace with - (dash).
Keep getting message that match cannot be found.

Not sure what I'm doing wrong but would like to replace all the 0.00 with
either a dash or leave blank.

thanks,

L.