Format to Currency

[fenhow]

Hi,

Is is possible to format this ([Fixed Minimum Price Per Acre]) to Currency inside the following code?

It currently shows 25 when I want it to show $25.00

="Minimum Payment Of " & " " & ([Fixed Minimum Price Per Acre]) & " " & "for a total of " & Sum([si_Grantee_Acres]) & " ac. "

Thanks.

Fen How

 

[boblarson]

="Minimum Payment Of " & " " & (Format([Fixed Minimum Price Per Acre],"Currency")) & " " & "for a total of " & Format(Sum([si_Grantee_Acres]),"Currency") & " ac. "

 

[boblarson]

Banmark reported for spam in post.