Excel data transfer add-in DATE fields

["Mail List" <maillist@xxxxxxxxxxxxxxx>]

Hi All,

I'm using the IBM CAExpress Excel add-in to download some data from an AS400
to a spreadsheet.  The problem is the file contains separate numeric fields
for a date's month, day and 4-digit year.  In order to get Excel to
recognize this as a date, I have something like this:

select digits(MONTH) || '/' || digits(DAY) || '/' || digits(YEAR) as DateFld
from Lib/File

but it comes across as a character value.  If I simple edit the cell
containing it without actually changing anything, Excel then recognizes it
as a date.  I could set up a macro do do this, but I'd prefer a solution
that doesn't require extra processing after downloading the data.

tia,
Peter Dow
Dow Software Services, Inc.
909 793-9050 voice
909 793-4480 fax
909 522-3214 cell