RDLC textbox properties to currency

Question

I have a textbox in RDLC. Now I want to change it into a currency format, but it does not work. The display value of my textbox looks like this: 2200, not like this: $ 2,200

IMAGE

I tried to change my textbox expression from this:

=First(Fields!total.Value, "DataSet1") 

IMAGE

to this:

=Format( First(Fields!total.Value, "DataSet1")  ,"0.00")

and not work for me

Answer 1

Use

=Format(First(Fields!total.Value, "DataSet1") , "C0")

You can also set the textbox properties: Number -> currency