Specify thousand separator in ssrs without specifying decimal

Question

MY database have values like 3302540.8200 748712.9600 584879.2400 20787.5300 1338075.0000

I need the above values like below in my SSRS reports 3,302,540.82 748,712.96 584,879.24 20,787.53 1,338,075

I tried custom format for number on my text box #,0.######## but while exporting it in excel it is showing the value 1 as 1. (dot is not desirable)

help me with this. TIA

Answer 1

Using the following as the datasource:

SELECT 3302540.8200 Number UNION
SELECT 748712.9600 UNION
SELECT 584879.2400 UNION
SELECT 20787.5300 UNION
SELECT 1338075.0000 UNION
SELECT 1000 UNION
SELECT 10123.20

You could use the following expression in your output table/Textbox:

=Format(Fields!Number.Value,"#,#.##")

Excel Output:

1,000
10,123.2
20,787.53
584,879.24
748,712.96
1,338,075
3,302,540.82