Hello to you all,
I have numbers in the range A1 to C3. One or two have the value "#VALUE!" instead of a number. I would like to add a button to the sheet so when they click it all the "#VALUE!" turn into a "0". Please note, this is NOT a formula so I can't simply sneak an ISERROR() into the little fella.
Your help would be greatly appreciated.
Many thanks in adVANCE, Alan.