ssis 2010 to excel 2013, cell format issue RRS feed

  • Question

  • Hi team

    I am using ssis 2010 to excel 2013, I am experiencing a cell format issue

    I have a date, I have even used a data conversion to make sure it is a date, but when the data enters the excel cell its


    I don't know why it is adding a ' symbol before the date

    also I have a number 7 coming across, and the cell is formatted to general before it reaches excel , but when shown in excel it is 7.0 as cell has converted itself to text! I don't know why this keeps happening

    please help

    Thursday, October 17, 2019 2:19 PM

All replies

  • billybobsonic,

    Sorry but you have posted to a forum that deals exclusively with questions/issues about customizing and programming for Microsoft Project, a project management application. I suggest you re-post to the following forum:


    Thursday, October 17, 2019 2:26 PM