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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
You can use a formula like this:
=DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I convert date/time formats differently? 4
Excel date format YYYYMMDD 1
How do I change the date format? 3
Date Conversion 1
test to Julian date 10
Date Problem 3
how do I convert date format yyyymmdd to mm/dd/yyyy 2
How do I convert 20091115 to date format in excel? 5

Back
Top