Convert a number to a date

  • Thread starter Thread starter Boop914
  • Start date Start date
B

Boop914

I'm working with data that's been downloaded from another source. Part
of the data represents a date, but it comes through as 90103 for Sept
1, 2003 or 111103 for November 11, 2003. Is there a way to format the
numbers so they would appear as mm/dd/yy?
 
Hi,

For a value of the kind your're using in A1, the following formula in, say
B1, will convert it to a date:
=DATE(RIGHT(A1,2),MID(TEXT(A1,"000000"),3,2),LEFT(TEXT(A1,"000000"),2))

Cheers
 
Boop

Using your examples.........

Data>Text to Columns>Next>Next. Format as Date--MDY

Gord Dibben Excel MVP
 
Back
Top