View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Charlie_Brown[_2_] Charlie_Brown[_2_] is offline
external usenet poster
 
Posts: 1
Default how to remove #N/A

I have a large spreadhsheet (21k rows) that creates alot of #N/A as designed.
I would like to change the #N/A to zero removing the formula. This is not a
one time deal as I need to re-create the spreadsheet weekly. I do not want
to value out the entire spreadsheet.