Hi there,

I have an excel sheet in which I export data from a SSIS package. This data has several columns, mainly text and integers. My problem is that, despite the format I put into the cells, Excel is showing all the data as text, even the numeric columns. When I take a look into the format of those cells, they appear as 'General'.

This wouldn't be a serious problem (I can change the type manually) if it weren't because I'm supposed to generate these sheets and send them by mail automatically, and also i have a pivot table within the document that of course is not displaying the data correctly.

Any idea on why could be this happening?

Thx in advance