Convert dates

[Guest]

I have downloaded a table that displays dates with a M/D/YY format. On my
PC, the format for dates is DD.MM.YY.

How do I convert from the text in the date colum of the downloaded table, to
a date displayed in my PC's format?

 

[Guest]

One way is to use Data > Text to Columns to convert the source text dates to
real dates. Try this: Select the source col of dates, click Data > Text to
Columns. Click Next > Next. In step 3 of the wiz., under Column Data Format,
check "Date", then choose MDY from the droplist. Click Finish. Now you can
custom format the dates in the column to taste.

 

[Guest]

Thanks Max. It did the job.

One way is to use Data > Text to Columns to convert the source text dates to
real dates. Try this: Select the source col of dates, click Data > Text to
Columns. Click Next > Next. In step 3 of the wiz., under Column Data Format,
check "Date", then choose MDY from the droplist. Click Finish. Now you can
custom format the dates in the column to taste.

 

[Max]

You're welcome.
Good to hear that.