View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] Destrachan@gmail.com is offline
external usenet poster
 
Posts: 25
Default How to display dash instead of #REF

Thanks for the quick answers, I really appreciate it. As for the data,
it's just ones and zeroes. This is a spreadsheet for QA purposes for
phone calls. Basically, a 1 means that the requirement has been met, a
0 means that it hasn't. Now, if the requirement was N/A, then the cell
is to be left blank.

This isn't something that's dreadfully important that needs fixed, it's
more of a minor annoyance that I'd like to see go away. :) Hope this
helps.