View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Karen Karen is offline
external usenet poster
 
Posts: 447
Default cells without values causing error message

I'm downloading data from a database into Excel; some of the cells have $0
values, but some are just blank. If I sum a row or a column which includes a
blank cell, I get an error message: #VALUE! How can I convert the blank
cells to zeros?
--
karen