Thread: Name Box and not picking up the correct value
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
DartGuru DartGuru is offline
external usenet poster
  
Posts: 7
Default Name Box and not picking up the correct value

Bob Phillips wrote:

Check that the cell/sheet format is not text, if so, change it to General



The format was already General.
Interestingly, if the cell containing the data which i am trying to
reference contains, for example, 3999, then looking at the format of
the cell that is not working, right-click - Format Cells, undeer the
Number tab, it shows category of general and a Sample of 3999.

Reply With QuoteReply With Quote