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

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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

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