RE: Dates into Excel

What is your Windows locale, specifically date format?
IIRC, Excel uses the Windows locale to determine the default date format.
The date format used in the data transfer should match the date format (MDY,
DMY, YMD) in Windows.

My local date format is USA (MDY), so I chose USA in the data transfer.

You should try the DMY or EUR formats in the data transfer format options to
see if Excel likes that. The default I see in format options is MDY. I don't
know if data transfer is smart enough to use/recognize the Windows locale.

HTH,
Loyd

Loyd Goodbar
Senior programmer/analyst
BorgWarner
E/TS Water Valley
662-473-5713
-----Original Message-----
From: Guy Terry [mailto:guy.terry@xxxxxxxxxxxxxxxxxxx] 
Sent: Tuesday, December 13, 2005 08:15
To: Midrange Systems Technical Discussion
Subject: Re: Dates into Excel

Thanks Loyd,

I can get results with all that - thanks.

What about sorting though?

File on the iSeries with two records -

12/01/06
13/01/05

Transfer into Excel and sort in ascending order. You and I both know 
that 13 Jan 2005 should come top, but it doesn't here. Not until I go 
into each cell in turn, do F2 to edit and then [Return]. At which point 
Excel formats the cell properly, and then sort works.

Guy