Convert all zeros to blank cells

A

Al Allen

I have many cells that contain 0 or $0.00. Is there a way to convert those to blank cells. Also, the data is in a pivot table and is dynamic (gets updated periodically).

?
 
D

Debra Dalgleish

If these cells are in a range that contains numbers only, you could do
the following:

Select the range that includes the zero cells.
Choose Edit>Replace
For 'Find What', enter a zero
For 'Replace With'
Click the Options button
Add a check mark to 'Match entire cell contents'
Click Replace All
Click Close

With the cells still selected, choose Edit>Go To
Click Special
Choose Constants
Remove check marks from Numbers, Errors, and Logicals, and
leave Text checked
Click OK
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top