Format Currency

  • Thread starter Thread starter Roger Bell
  • Start date Start date
R

Roger Bell

I have the following text box in a report:

=Trim("Thank You for your Total Contribution of" & "" & [text235])

I would like the [text235] to be displayed as currency with 2 decimal
places. Could someone please advise where I add the Format Currency command
and the correct placement?

Thanks for any help
 
=Trim("Thank You for your Total Contribution of " & Format(CCur( [text235]),
"Currency"))
 
I have the following text box in a report:

=Trim("Thank You for your Total Contribution of" & "" & [text235])

I would like the [text235] to be displayed as currency with 2 decimal
places. Could someone please advise where I add the Format Currency command
and the correct placement?

Thanks for any help
Click to expand...

="Thank You for your Total Contribution of " & Format([text235],
"$#,##0.00")
 
Back
Top