How to remove only 0 (Zero) values from column in excel 2010

Question

I want to remove the values from entire column where cells value is 0.

The resultant Cells should be blank.

How can I write a formula for this? Any suggestions?

TELEPHONE NUMBERS
----------
49 5235102027   <-- Cell has 0 value but shouldn't removed!
35 2578945655
0               <-- Remove this   
90 5322720638
48 5396329155

Answer 1

I selected columns that I want to delete 0 values then clicked DATA > FILTER. In column's header there is a filter icon appears. I clicked on that icon and selected only 0 values and clicked OK. Only 0 values becomes selected. Finally clear content OR use DELETE button. Problem Solved!