In case anyone is interested, F5SpecialBlanks only picks up true blanks but not null strings (="") returned by formulae.

I enter ="" into a blank cell, and it is not replaced by 0.

Epinn

"Gord Dibben" <gorddibbATshawDOTca wrote in message ...
F5SpecialBlanksOK

Type 0 in active cell then hit CTRL + ENTER


Gord Dibben MS Excel MVP

On Thu, 26 Oct 2006 16:37:02 -0700, Peter
wrote:

I have thousands of empty cells which I would like to replace with zeros, but
opening Find and Replace, clearing the Find field and entering 0 in the
Replace field replaces zeros in larger numbers I don't want edited.