locked
format on export to excel RRS feed

  • Question

  • Hi,
    When I export a report to excel I see all columns as text formatted fields.
    How does the formatting work on export?
    Do the number fields get exported to excel as number formatted columns and general format in ssrs get exported as text columns?
    Thanks
    Friday, April 19, 2013 9:17 AM

Answers

  • Hi Arkiboys,

    Base on my test, the number fields get exported to Excel as number columns. Because we can add number filters to the columns which are number fields in the report.

    If you have any questions, please feel free to ask.

    Regards,
    Charlie Liao

    If you have any feedback on our support, please click here.  


    Charlie Liao
    TechNet Community Support


    • Edited by Charlie Liao Monday, April 22, 2013 2:12 AM
    • Marked as answer by Charlie Liao Thursday, April 25, 2013 8:17 AM
    Monday, April 22, 2013 2:11 AM

All replies

  • Hi Arkiboys,

    Base on my test, the number fields get exported to Excel as number columns. Because we can add number filters to the columns which are number fields in the report.

    If you have any questions, please feel free to ask.

    Regards,
    Charlie Liao

    If you have any feedback on our support, please click here.  


    Charlie Liao
    TechNet Community Support


    • Edited by Charlie Liao Monday, April 22, 2013 2:12 AM
    • Marked as answer by Charlie Liao Thursday, April 25, 2013 8:17 AM
    Monday, April 22, 2013 2:11 AM
  • Hi Arkiboys,

    Base on my test, the number fields get exported to Excel as number columns. Because we can add number filters to the columns which are number fields in the report.

    If you have any questions, please feel free to ask.

    Regards,
    Charlie Liao

    If you have any feedback on our support, please click here.  


    Charlie Liao
    TechNet Community Support


    Hi,
    How about if the field in the report is like £25.4
    Does that still comeout as number format in excel or text?
    Thanks

    Monday, April 22, 2013 7:41 AM
  • Hi Arkiboys,

    If the field in the report is like £25.4, it's still as number columns after export to Excel.

    Regards,


    Charlie Liao
    TechNet Community Support

    Monday, April 22, 2013 8:08 AM