Data Validation-List

  • Thread starter Thread starter CP
  • Start date Start date
C

CP

Hi All,

I am trying to do a drop down list with all the week
ending dates in 2004. I have all the dates listed in
cells X13:X70. The drop down list will go in cell U5.

I have X13:X70 in the Source, but the actual drop down
list in U5 won't give me the list of dates, it only gives
me "X13:X70" as a choice.

What do I need to do to have the dates, not the formula in
the drop down list?

Thanks, CP
 
Thanks, JE, That didn't work either! I just get
$X$13:$X$70 as a choice, not the actual dates.

Thanks, CP
 
Dave,

You are fabulous! I guess the equals sign was one of
those Duh Things! I should learn to read. Anyhow, thank
you soooo much!

CP
 
Back
Top