Thanks for the suggestion. I was trying to avoid doing this. I have 115,000
records in 6 spreadsheets and they we have to be recreated on a regular basis.

"gls858" wrote:

Mike wrote:
For all cells in a column, E2 - E20, that contain a value of 0, how can you
change the value to a space while making no changes to cells containg a value
0?

Find and replace? Select the cells find 0 change to blank

gls858