Data Validation-List

[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

 

[J.E. McGimpsey]

Anwered in .newusers about 8 hours ago.

 

[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 Peterson]

Did you really include the equal sign?

=x13:x70
not
x13:x70

 

[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