Highlight entire sheetGrey Square above the 1 and to the left of A. then
EditReplace (...) with 0
REPLACE ALL

"Shannon Y" wrote in message
...
How to replace (...) with a 0. what the quickest way for hundreds of
cells