Thanks for the info.
Learn something new everyday.

"Tyro" wrote in message
. net...
If your cells are 0's formatted as 0.00, Find/Replace will not find 0.00
as the cells do not contain 0.00, the cells contain 0. It appears you're
confusing the cell content, 0, with the formatting of the cell as 0.00 for
display purposes. You can format your cells with 0 to display as - (dash)
with custom formatting of #;-#;- or as blank with #;-#;


Tyro

"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.