When I run a pipe delimited baan report to the device excelxp, the date fields appears fine, but then in excel I do a text to column's and the date columns show as ##########. Once I make the column bigger in excel, the date fields look fine again. Is there a way in baan to increase the size of the date field that gets downloaded into excel so that the columns dont show as ##########. Any help would be appreciated.

I solved this by writing a macro that auto sizes the columns.