I have a range of cells a35:a243
If the cells contain any number other than 0, replace with 0
I have a sheet that I select a quanity of product a35:a243, and I start a new quote, I want to set all quanties to 0 Zero
when the quanity <> 0, I want to set that cell to 0
Note: Within the range I have charactor fields that I want to leave as is, Only want to effect numbers <> 0 to set them to 0
Bookmarks