How do you change a date that is in the yyyymmdd format to mmddyy

N

Norton

I have a spreadsheet that contains a date in the format of yyyymmdd and I can
not get it to convert to a different date format
 
D

Dave Peterson

Is it one column?

Select that column
data|text to columns
fixed width, but remove all those lines that excel guesses and don't draw any
yourself.

Choose ymd as the format for the field.

And finish up.

If you have more than one column, do each separately.
 
M

Miguel Zapico

You can use a formula like this:
=DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))
 
Top