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