Thread: Ignoring #n/a
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
The Toasterman
 
Posts: n/a
Default Ignoring #n/a

A spreadsheet I am working on return #n/a into a cell as it only dins a blank
in the validation menu we are using.

Is there any way to get excel to ignore #n/a & show a blank?