Dates in Excel 2007

[Delita]

I have an excel file with a ton of dates, each in the format of yyyymmdd with no seperators of any kind. I need to convert that number to mm/dd/yyyy with the seperator. Any suggestions?

 

[mayest]

You need to use the Date() function combined with some string functions. Something like =DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2)). I've got a related blog post about this using a different date format.

 

[Delita]

Worked great. Thanks. Excellent blog as well. Adding to favorites.