Can I format this result on the report?

[Vegaanders]

Hi!
I have a textbox in my report that get its content from this

="Total paid to bank" & " " & ([Expenses]+[Salary_Euro])/100*99 & " €"

Is there any way to format the output. Like today it show 10395, it should be 10 395.

Thanks in advance
Anders

[ranman256]

Format((fld1/fld2),"currency")

[Vegaanders]

Thank You, I will try that.

I have a connecting question. If I format a fielt currency I end up with a poundsign or a €. I want one with $. Is this because I have UK English installed?

Anders