Excel - how do I change the date format from yyyymmdd to mm/dd/yyyy

Asked By Charlene on 16-Sep-09 12:09 PM
how do I change the date format from yyyymmdd to mm/dd/yyyy




Eduardo replied on 16-Sep-09 12:19 PM
Hi,
highlight the range, right click on the mouse, custom format, type mm/dd/yyyy
David Biddulph replied on 16-Sep-09 12:27 PM
Format/ Cells/ Number/ ...
--
David Biddulph
Glenn replied on 16-Sep-09 12:50 PM
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))
Gord Dibben replied on 16-Sep-09 03:13 PM
Data>Text to Columns>Next>Next>Column Data Format>Date>YMD and Finish


Gord Dibben  MS Excel MVP