Thread: Reference to cell with text is returning #VALUE
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jorist Jorist is offline
external usenet poster
  
Posts: 3
Default Reference to cell with text is returning #VALUE
I have a cell that references a different cell that that consists of H9:J9
that is formated for and contains text.

The referenceing cell shows #VALUE instead of the actual text that is in the
cell?

Any ideas as to why this is happening? Any help would be appreciated.
Reply With QuoteReply With Quote