Thread: How do I find and replace null values in Excel 2002 worksheets?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default How do I find and replace null values in Excel 2002 worksheets?
Did you leave that What box empty or did you type a spacebar?



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.
--
Thank you,
Peter

--

Dave Peterson
Reply With QuoteReply With Quote