Convert dates
 

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?

Convert dates
 

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
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"hmm" wrote:
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?

Convert dates
 

Thanks Max. It did the job.

"Max" wrote:

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
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"hmm" wrote:
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?

Convert dates
 

You're welcome.
Good to hear that.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"hmm" wrote in message
...
Thanks Max. It did the job.