E Eduardo Sep 16, 2009 #2 Hi, highlight the range, right click on the mouse, custom format, type mm/dd/yyyy
G Glenn Sep 16, 2009 #4 Charlene said: how do I change the date format from yyyymmdd to mm/dd/yyyy Click to expand... If your data is actually numbers that look like dates in the format "yyyymmdd", then you would need to do something like this: =DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))
Charlene said: how do I change the date format from yyyymmdd to mm/dd/yyyy Click to expand... If your data is actually numbers that look like dates in the format "yyyymmdd", then you would need to do something like this: =DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))
G Gord Dibben Sep 16, 2009 #5 Data>Text to Columns>Next>Next>Column Data Format>Date>YMD and Finish Gord Dibben MS Excel MVP
