create date from 5 digits

[gkeppler]

I have a date that comes into excel as 32409, which is not a serial date, but rather March 24, 2009. Is there a way to convert it to a date? or to insert a slash two from the right and four from the right? So, turn 32409 into 3/24/09. Thanks

 

[c_m]

right click on cell>>number tab>>select Custom and paste this in Type field:
mm/dd/yy

 

[VoG]

Hello and welcome to MrExcel.

Try this: select your dates, Data > Text to Columns, click Next twice then on the third screen check Date, select MDY and click Finish.

 

[PATSYS]

I have a date that comes into excel as 32409, which is not a serial date, but rather March 24, 2009. Is there a way to convert it to a date? or to insert a slash two from the right and four from the right? So, turn 32409 into 3/24/09. Thanks

Assuming 32409 is in cell H14.

=DATE("20"&RIGHT(H14,2),LEFT(H14,1),MID(H14,2,2))

 

[Scott Huish]

=TEXT(A1,"00\/00\/00")+0

Format as m/d/yy