Home Forums SQL Server 2012 SQL 2012 - General Retain leading zero's while exporting SSRS report to excel RE: Retain leading zero's while exporting SSRS report to excel

  • January 28, 2015 at 2:54 pm

    #1773826

    kk.86manu (1/28/2015)

    Hi All,

    I have a query in a SSRSreport that returns a value that looks like '012345'.The value looks fine on the report preview screen.

    When the report is exported to excel, that value is displayed in a cell as '012345'.When I click out of the field, excel is dropping the leading zero and converting the value in the field to 12345.

    Why is this happening and i have converted the value as string as well using expression.

    Thanks for your help

    That is a function of how Excel displays numeric values. To display the leading zeroes, you have to change the Excel cell.

    Tom