View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default 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.