locked
Export to Excel RRS feed

  • Question

  • User900934948 posted

    Does anybody knows how to export SSRS report to Microsoft Excel with the column as "number" in format cells options. As you can see above is the exported report but it is in "general" but i want it to be number instead. Please help

    Tuesday, March 25, 2014 5:53 AM

Answers

  • User-8475372 posted

    Dear User, 

    For the column on the report, right click and change the expression to =Format(Fields!YourField.Value,"N"). This will help to export in numerical format.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Tuesday, April 1, 2014 7:41 AM

All replies