Convert from a specific date format

If A1 is 81209, how can I use functions in B1 to convert it into DEC/09/2008? Thanks.

Hi,

Try this

=DATE(LEFT("0"&A1,2)+2000,MID("0"&A1,3,2),RIGHT("0"&A1,2)) Custom format cell to mmm/dd/yyyy

Another way again based on the assumption that you're using yearMMDD -- ie Jan 1 = 0101 and NOT 11

Enter 20,000,000 in a blank cell.

Copy it --> Highlight your date values -> Edit -> Paste Special -> Operation = Add

Now highlight your revised values and use Text to Columns --> jump to step 3 and choose Date -> YMD -> Click Finish.