Export to Excel

[jjlbmcnews]

Hi,

I use DTS to export to excel, I've found a problem where by I can't total a column in Excel that contains a list of numbers even though the format of the cell in Excel is Number. This only seems to happen when I use DTS to export the rows to the spreadsheet, has anyone else experienced this?

 

[sedgely]

I had the same problem, the way i got round this is to highlight the column in Excel and then from the Data menu select 'Text to column'.
i have recorded this as a macro that runs on open.
I'm sure there's a better solution out there though.



Cheers, Craig
Si fractum non sit, noli id reficere