Jump to content
Sign in to follow this  
ljm

Adding a comma to a number in a paragraph

Recommended Posts

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.

Share this post


Link to post
Share on other sites

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 by Guest
Added example

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

See if this works for you.

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

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

By using this site, you agree to our Terms of Use.