Thread: How do I tell Excel to "ignore" invalid numeric data?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
BruceA BruceA is offline
external usenet poster
  
Posts: 1
Default How do I tell Excel to "ignore" invalid numeric data?
I have a spread sheet that I want to enter text in a field that is being used
in a SUM. I want Excel to ignore the text and treat it as Missing Values (or
zero). The SUM currently gets a #VALUE! error.
Reply With QuoteReply With Quote