• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

Dates in Excel 2007

Delita

Delita

Senior member
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?
 
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.
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top