Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  Analysis Server and Reporting Services (2005)  Export excel with decimals

Author  Topic  volyn Starting Member 30 Posts Posted - 2010-06-07 : 05:16:07 Hello, my report uses as datasource Stored procedure, which returns table ,where are 2 columns of real type. I put this value to table (no other ssrs functions is used) - format of field is set to P0. When i run report in report manager, then everything looks really nice, after I export result to excel, then what was shown in report manager as 6% is in excel shown as 6,% . Do you have idea how to avoid decimal mark to be shown in excel ? thanks a lot