Hi,

I was able to amend the format of the spreadsheet before I imported it.

As we have a automated process of importing the file, I'd be interested to see if you could execute a macro via SSIS to export it first. 🙂

Thanks,

Graham