You have to format both as Date, the cell where the data validation occurs
and the cells where the List is.
--
If this posting was helpful, please click on the Yes button.
Regards,

Michael Arch.




"caldog" wrote:

Have a list of dates from present through the end of year, usually only
Wednesday through Saturday in Book 1, and named the range of dates. Then I
opened a new we will call Book 2 and tried using Data Validation but all I
see in my dropdown box is the Excel numbers associated with those dates. Now
I went back and made sure that I had set each column in both books to the
proper date format. But alas nothing has changed. What I'm I doing wrong?
The format I would like to see the dates in is: 03/04/07.

Thanks

Steve