dollar amounts

[moon0129]

How do show numbers as a dollar amount in a calculation. The calculation contains text and the number so I can't use the Format::Number option.

I need: Project 1 - $1,000

I am getting Project 1 - 1000

I know I can get the $ by using "$" & Number, but this doesn't add thousands separators.

Any easy solutions?

[Ender]

You might check this thread:

http://forum.filemakermagazine.com/viewtopic.php?t=5029

[moon0129]

very helpful... thank you!

[comment]

Actually, the EASIEST solution is to use merge fields.