Why does the date change from "January 07" to a numercial value of "39038 "
Hmm, I would have thought that 39038 would correspond with November 06.
The date is stored as a decimal number, where 1 is the equivalent of 1
day. 1 represents 1/1/1900, 2 represents 1/2/1900, 39038 represents
11/17/2006.
Hours and minutes are represented by the fractional part of the number.
Are you sure it wasn't 39088? (That would correspond to January 07)
Scott
Corey wrote:
Private Sub UserForm_Initialize()
With Sheet1
Me.ComboBox1.RowSource = "B17:B28"
Me.ComboBox1.Text = Format(Me.ComboBox1.Text, "mmmm yy")
End With
End Sub
|