Rearranging formats of dates for sports schedules

[Lynne]

My boyfriend loves various American sports, their home internet pages tend
to have the option to download the team schedules.

The format is obviously American, but he wants to convert the CSV file to
suit a UK Calendar layout.

Any suggestions for a small software tool that can convert CSV formats?

Lynne

 

[Diane Poremsky [MVP]]

What happens if he just imports them? Outlook should understand the data and
make the format changes for you.

--
Diane Poremsky [MVP - Outlook]



Outlook Tips by email:
(e-mail address removed)

EMO - a weekly newsletter about Outlook and Exchange:
(e-mail address removed)

You can access this newsgroup by visiting
http://www.microsoft.com/office/community/en-us/default.mspx or point your
newsreader to msnews.microsoft.com.

 

[Lynne]

The format remains as the original, so that May 4th 2009 listed as
05/04/2009 will be inserted into a European (British Calendar) as 5th April
2009 and therefore the team schedules will be messed up.

Any other suggestion would be gratefully recieved.

Lynne

What happens if he just imports them? Outlook should understand the data
and make the format changes for you.

--
Diane Poremsky [MVP - Outlook]



Outlook Tips by email:
(e-mail address removed)

EMO - a weekly newsletter about Outlook and Exchange:
(e-mail address removed)

You can access this newsgroup by visiting
http://www.microsoft.com/office/community/en-us/default.mspx or point your
newsreader to msnews.microsoft.com.

My boyfriend loves various American sports, their home internet pages
tend to have the option to download the team schedules.

The format is obviously American, but he wants to convert the CSV file to
suit a UK Calendar layout.

Any suggestions for a small software tool that can convert CSV formats?

Lynne

 

[Diane Poremsky [MVP]]

what if you change the dates to 2009/05/04 format? (It should be fairly easy
in Excel). Or change the computer date format to US, import, then change
back to UK.

--
Diane Poremsky [MVP - Outlook]



Outlook Tips by email:
(e-mail address removed)

EMO - a weekly newsletter about Outlook and Exchange:
(e-mail address removed)

You can access this newsgroup by visiting
http://www.microsoft.com/office/community/en-us/default.mspx or point your
newsreader to msnews.microsoft.com.

The format remains as the original, so that May 4th 2009 listed as
05/04/2009 will be inserted into a European (British Calendar) as 5th
April 2009 and therefore the team schedules will be messed up.

Any other suggestion would be gratefully recieved.

Lynne

What happens if he just imports them? Outlook should understand the data
and make the format changes for you.

--
Diane Poremsky [MVP - Outlook]



Outlook Tips by email:
(e-mail address removed)

EMO - a weekly newsletter about Outlook and Exchange:
(e-mail address removed)

You can access this newsgroup by visiting
http://www.microsoft.com/office/community/en-us/default.mspx or point
your newsreader to msnews.microsoft.com.

My boyfriend loves various American sports, their home internet pages
tend to have the option to download the team schedules.

The format is obviously American, but he wants to convert the CSV file
to suit a UK Calendar layout.

Any suggestions for a small software tool that can convert CSV formats?

Lynne