Delete 0's in Excel

I have a column (C) with a lot of numbers in it. How can I have excel delete all the cells that have a 0.00 value? I just want the cell deleted not the whole row. Any idea?
cansevinAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Saqib Husain, SyedConnect With a Mentor EngineerCommented:
Select the data
Do      Data > Filter
From the dropdown at the top select only 0.0
select the zeros
press the delete button
0
 
cansevinAuthor Commented:
You the man, thanks!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.