replacing 0's

  • Thread starter Thread starter L.S.
  • Start date Start date
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.
 
Format the cells as Accounting

--
HTH

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
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
 
Worked. thanks
Is there a reason why the Find and Replace didn't work with currency format?

L.
 
Back
Top