How do I change my date from this format 20070507 to 05/07/07?

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

Guest

How do I change my date from this format 20070507 to 05/07/07? My Data
retrieval program puts my date in this format YYYYMMDD. I can't figure out
how to to change it to MM/DD/YY. Can any one help?
 
Those are probably not real dates. Use Data > Text to Columns on the col of
dates. In step 3 of the wiz, check "Date" under "Column data format", then
select YMD from the droplist. Click Finish. Now you can format the real dates
to taste.
 

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

dd/mm/yy if i change to some other format 2
Unique values from date range 1
Date format - India/USA 7
convert number to date in excel 2003 2
create a month column from date column 4
Excel (or other) macro for cleaning date data 3
Data validation - dates 1
How do I get total amount of hours in time format 3

Back
Top