View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
GS GS is offline
external usenet poster
 
Posts: 364
Default Problem with creating a named range

I failed to mention that my DV drop list looks the same as the DV Source box
entry.

ie:
Jan 06
Feb 06
Mar 06
Apr 06
May 06

...and the data appears that way in the cell after selection. Formatting the
cell as TEXT will correct how it appears in the DV drop list, and prevent
Excel from interpreting it as a date.

HTH
Garry