replacing 0's

L

L.S.

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

Sandy Mann

Format the cells as Accounting

--
HTH

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

[email protected]
Replace @mailinator.com with @tiscali.co.uk
 
T

Tyro

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

L.S.

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

L.
 
Top