I have a date format, 20051201, what is the formula to convert to 12/02/2005
D Douglas J. Steele Dec 2, 2005 #2 What's the value stored in: a number, or a string? For a string, try DateSerial(Left$(DateField, 4), Mid$(DateField, 5, 2), Right$(DateField, 2)) For a number, try CDate(Format(DateField, "0000\-00\-00"))
What's the value stored in: a number, or a string? For a string, try DateSerial(Left$(DateField, 4), Mid$(DateField, 5, 2), Right$(DateField, 2)) For a number, try CDate(Format(DateField, "0000\-00\-00"))
