View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
COL COL is offline
external usenet poster
 
Posts: 3
Default Replacing an ERROR message with "NA"

I have created a table and some of the cells display the message "#DIV/0"
which I expected would happen, yet I want to automate the document so that
all error messages are replaced by the text message "NA". It's a large
document and it would take a very long time to change each cell manually so I
was hoping someone could help me. I also update it often, therefore I need to
keep the formula in the cell and if I type NA in the cell the formula will be
erased...

Does anybody know how to fix this?