Convert all zeros to blank cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

?
 
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
 
You must log in or register to reply here.

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

Similar Threads

Blank Cells vs. Zero Values 2
How to convert numbered cells into blank 2
Counting blanks as zeros 1
Hiding blank cells within a Pivot Table 1
Trying to get a blank cell presented if B26=0 4
sumif returns blank if all cells blank 7
Hide zero cells in pivot table. I don't want the cell to appear . 1
Converting decimals to Time 4

Back
Top