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.