I have 2 workbooks. Workbook 1 contains named ranges one of which is a list
of payroll numbers. Workbook 2 has a column to select these payroll numbers
in a drop down lists using validation, lists, the named range. This has all
worked perfectly well for a couple of months, however, today the drop down
list no longer displays the payroll numbers as numbers but as dates. When one
of the dates is selected it drops the number into the cell in the correct
format ie payroll number. Does anyone know why this is happening?