Hi Jay

Maybe you need to format the cells with the Data Validation, the same as
the cells in you source list.

--
Regards

Roger Govier


"Jay Trull" <Jay wrote in message
...
I have created a drop down list from a range of cells that are in a
sheet in
a different workbook. When I click on the list, the format of the
dates or
time is incorect on the drop down list. Does anyone know how to fix
this?
If the sheet is in the same workbook the format is fine.