Hi

You have to format the cell' where you select the date, too. Formatting the
data validation list range determines only, how are selections in drop-down
displayed. You can format the destination cell in same way, or differently,
as you like. It's mystery to me, why you didn't success with it - maybe you
try again.

--
When sending mail, use address arvil<attarkon.ee
Arvi Laanemets


"Steven Cheng" wrote in message
...
I have a dropdown box that is linked to a cell where a date is put that is
used for other things. The drop down box is filling itself from a range,
which contains a sequential list of dates. I have verified that the dates
are indeed dates and not text values. However, whenever I select a date
using the drop down list, the link cell reverts to a serial format. I
have
tried to reformat the cell to be mm/dd/yyyy manually but without any
success.

Should be a simple reason but I am stumped here.