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

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

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

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.

Norton wrote:

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

--

Dave Peterson

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

You can use a formula like this:
=DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))
--
It is nice to be important, but it is more important to be nice


"Norton" wrote:

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