Thread: Replace #VALUE! in cells of a worksheet
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Peterpunkin
 
Posts: n/a
Default Replace #VALUE! in cells of a worksheet
How can I replace the result "#VALUE!" where it occurs in a worksheet with
"N/A"
or else how can I have the cell to the right of any cell bearing N/A also
display N/A?
Reply With QuoteReply With Quote