Find Replace for only 0 and not 10

[Guest]

I have a report that has a lot of 0 in it and I need to delete them. I tried
to use the Find Replace function to take out the 0's but it takes the 0's out
of the 10's and any number with a zero in it. Is there a way to only take
out the zeros with this function or a similar one?

 

[Roger Govier]

Hi

It depends upon what you have, but maybe Tools>Options>View>untick Zero
values would do what you want.

 

[Trevor Shuttleworth]

Click on the options button to expand it. Then choose Match entire cell
contents.

Regards

Trevor

 

[Gord Dibben]

The Find>Replace dialog box has an "Options" button.

Select it and then checkmark "match entire cell contents"


Gord Dibben MS Excel MVP

 

[Pete_UK]

Another way of hiding the zeros is to apply conditional formatting to
the cells - if Cell Content is zero then change the foreground colour
to white (or whatever the background colour is). That way you wont see
them, but you don't lose your formulae, so if values change then the
cells will become visible again.

Hope this helps.

Pete