Jump to content
Sign in to follow this  
Drew Sanderson

Format Merge Field Number

Recommended Posts

I have a number in a number field that is for US Dollars. How do I format the number to display as a merge field with two decimal places. If it is possible to have it do the dollar sign as well that would be great but I can just preceed the field with a typed in dollar sign.

Thanks,

Drew

Share this post


Link to post
Share on other sites

Hi

while in Layout mode select that merge field and format it as you like ( exactly like any other number field )

Share this post


Link to post
Share on other sites

I can't do any better than send an example file.

Localization is for Italy, but you can clone it.

merge.zip

Share this post


Link to post
Share on other sites

Thank you for taking the time to make me a sample file. I see how it works... My problem must involove something that is throwing that off. I have yet to figure that out since I was able to make it work in other areas.

Thanks again for taking the time!

Drew

Share this post


Link to post
Share on other sites

For Drew_S (if he is still around)or those who got here by searching "merge" (as I was):

The thing is that you can choose easily the format when the merge field is alone, with no text else either before and after it. But when it is in the middle of text, you are not able to select a format (they are dimmed); what I have experienced is that before you type or insert the merge field,and without selecting ANYTHING, you have to choose the format you will need for the merge field in the Format menu. After that, FM assigns the format you need.

Tks.

Share this post


Link to post
Share on other sites

The way it works is that the number/date/time formats are applied to the entire text object that contains the merged field/s. If the text object is selected, you can format it - otherwise the default format (the one selected with no layout object being active) is applied.

See also:

http://www.fmforums.com/forum/showpost.php?post/191506/

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.