It sure looks like it describes your original problem--not the =vlookup() one,
though.

Steven Cheng wrote:

Dave;

I found this on the knowledgebase. Would this explain why?

http://support.microsoft.com/default...b;en-us;170442

"Dave Peterson" wrote:

Is this a dropdown from the Forms toolbar or a combobox from the control toolbox
toolbar?

When I tried a dropdown from the Forms toolbar, I saw the dates listed
nicely--both in the dropdown and when it was selected (in the dropdown).

But with the combobox from the control toolbox toolbar, the chosen value looked
like the date's serial value.

But I could format the value the way I wanted if I used code.

Go into design mode (an icon on that same control toolbox toolbar).
double click on your combobox.
paste this code in:

Option Explicit
Dim blkProc As Boolean
Private Sub ComboBox1_Change()
If blkProc = True Then Exit Sub
With Me.ComboBox1
blkProc = True
.Value = Format(.Value, "mm/dd/yyyy")
blkProc = False
End With
End Sub

(I used combobox1. Change that if necessary.)

Steven Cheng wrote:

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.

--

Dave Peterson


--

Dave Peterson