Adding a comma to a number in a paragraph

[ljm]

I'd like to us a number in a thank you letter but can't get the calculation to show a comma. So here is the calc

"Thank you for your donation of$" & getastext(trans_amount)& " your donation will. . .etc."

Is there a function to add a comma to the number?

Thank you in advance.

[LaRetta]

Use a merge field instead of a calculation. And simply refer to the number field within it. When you do, you can then select the merge field and go to Field Behavior and Number Format. From there, since it is the only number in the merge field, you can specify number formatting, including number of decimals and using comma separator.

So your merge field would look something like:

Thank you for your donation of <>. Your donation will. . .etc

Now you can format the number.

Edited May 20, 2009 by Guest
Added example

[ljm]

Thanks for the recommendation. I find the merge fields don't really line up well in a paragraph format, so I'd prefer to use a calculation. Is there any way to force the format in the number within the calc?

Thanks again.

[mr_vodka]

See if this works for you.

http://fm.fmcode.com/fmcode/codeDetail.php?id=1946

[comment]

You could try:

"Thank you for your donation of $" & NumToJText ( Amount ; 1 ; 0 ) & " your donation will. . .etc."

However, a merge field is simpler to implement and it should work perfectly well.