View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Lynne Lynne is offline
external usenet poster
 
Posts: 21
Default find and replace Excel 2007

In 2003 I used to be able to select a range that contained blank cells and
use find and replace to change the blanks to 0 for an array formula to work.
Now 2007 says it can't find any matching data if I leave the find field
blank. Any ideas? There are alot of empty cells that need a 0 value!

Thanks