SSRS Formatting a string to a comma number

Question

I have the following value in one of my fileds in SSRS:

=CStr(Fields!Shipment_Weight.Value) + "#"

I do this becuase I need the #(pounds) sign at the end. This now does not allow me to format the number into something like 1,000 it gives me 1000 currently. Is there a way to add commas in the code rather than the format box since this is a string now? Values are all different from 1-1000000000

Thanks!

Answer 1

I found the answer it is as follows:

=CStr(FORMAT(Fields!Shipment_Weight.Value,"N0")) + "#"

That is how you use formatting code without having to put it in the formatting properties box.