I cannot get time format to display in a drop-down list
 

Good Afternoon.

I had drop-down lists with time selections in a master Excel file. I then
pulled out those worksheets and saved them to independent files. When I
redirect the drop-down list to the appropriate list of times in another
workbook, they now display as fractions of an integer in my drop-down list.
Both the list that I select from and the cells with the drop-downs are in the
proper time format. Once the fraction is selected, it displays as the proper
time. How did this happen and/or how can I get the time format to display
correctly in the drop-down list?

Thanks in advance.