Thanks Anne.

I was expecting something more complex (such as a formula) and never thought
to use such a simple solution.

Thanks again.

"Anne Troy" wrote:

Probably Edit--Replace, and make sure you hit the Options button and choose
"Match entire cell contents". Put a 0 in the Find box, and don't put
anything in the replace with box, and hit Replace all.
*******************
~Anne Troy

www.OfficeArticles.com


"pewe" wrote in message
...
What is the easiest way to 'empty' cells in Excel.

I have a large spreadsheet full of numeric values. If the value is '0' I
need to remove it to empty the cell.

What is the easiest way to empty these cells?