How to add a pound symbol(£) before the formula in textbox

Question

Here is my piece of formula in a textbox

=Fields!TotalCost2.Value+Fields!TotalCost1.Value

Now i want to add a £ in the formula so that the output will be

£ 300.00

Thanks in advance!

Answer 1

You simply need to type in the alt code for the pound symbol(£).

ALT + 0 + 1 + 6 + 3

Then you can enter the following into your formula:

="£ " & Fields!TotalCost2.Value+Fields!TotalCost1.Value

I am assuming that this will be statically declared, and it does not need to change across currencies.

It's the same as any concatenation like in this question How to concatenate values in RDLC expression?

Answer 2

If you set TextBox.Format = "C2" it will display the symbol declared in your regional settings ("C") formatted with 2 decimal digits ("2").