Exporting decimal value 15.00 in excel file.
When i am exporting into excel then 15.00 value is showing me 15 value.Is there way to show the value 15.00 in excel.

June 18th, 2015 11:01am

Hi Santosh, 

According to your description, you want to reserve two decimal places for the number, when exporting to excel, right? 

In Reporting Services, we can use Format () function to return an expected format. And this format will be kept in Excel. In your scenario, you can use the following expression to achieve your requirement: 
=Format(Fields!value.Value,"F2")

If you have any question, please feel free to ask. 
Regards, 
Shrek Li

Free Windows Admin Tool Kit Click here and download it now
June 18th, 2015 11:04pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics