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
 
Back
Top