Date Conversion

  • Thread starter Thread starter Guest
  • Start date Start date
Select cells to format

Format/Cells/Number Tab/Date -1st date format on the list

Disclamer - may differ depending on regional settings
 
Select the column with the "dates", do data>text to columns, click next
twice, under column data format select date and YMD, click finish
 

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

Copnvert dates reading as Text to a date format 5
Excel 2002: How to make the date format uniform ? 1
date in the form of yyyymmdd 2
Date Formats 1
date 1
Date format changes in mail merge using Excel worksheet as data 2
reformat dates to yyyy/mm/dd 5
Formatting Dates from Text to Numbers 2

Back
Top