How do I find and replace null values in Excel 2002 worksheets?
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.
|