| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data Validation using Dates
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Validation Data using Validation Table cell range..... | Excel Discussion (Misc queries) | |||
| Data validation - dates | Excel Discussion (Misc queries) | |||
| data validation invalid in dynamic validation list | Excel Worksheet Functions | |||
| Data validation with validation lists and combo boxs | Excel Discussion (Misc queries) | |||
| Validation using dates... w/o actual dates | Excel Discussion (Misc queries) | |||
Threaded Mode
