Convert dates

H

hmm

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?
 
M

Max

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.
 
H

hmm

Thanks Max. It did the job.

Max said:
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.
Click to expand...
 
Top