How to remove trailing zeros using ssrs?

Question

I have a column DECIMAL(18,4). when I insert data like 123.45 it becomes 123.4500 I want to show it in SSRS like 123.45. How to remove those zeros in SSRS?

Answer 1

Depending on what exporting formats your need you can set the number formatting to 0.####;(0.####)

I know this is compatible with the SSRS viewer and exporting to PDF, but Excel would take 123.0000 and show it as 123. instead of just 123