Drew Sanderson Posted April 24, 2007 Share Posted April 24, 2007 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 Link to comment Share on other sites More sharing options...
Raybaudi Posted April 24, 2007 Share Posted April 24, 2007 Hi while in Layout mode select that merge field and format it as you like ( exactly like any other number field ) Link to comment Share on other sites More sharing options...
Drew Sanderson Posted April 24, 2007 Author Share Posted April 24, 2007 I tried that with no luck. Format number is greyed out. Link to comment Share on other sites More sharing options...
Raybaudi Posted April 24, 2007 Share Posted April 24, 2007 Check that it is a number field. Link to comment Share on other sites More sharing options...
Drew Sanderson Posted April 24, 2007 Author Share Posted April 24, 2007 It is and I just re-checked it. Link to comment Share on other sites More sharing options...
Raybaudi Posted April 24, 2007 Share Posted April 24, 2007 I can't do any better than send an example file. Localization is for Italy, but you can clone it. merge.zip Link to comment Share on other sites More sharing options...
Drew Sanderson Posted May 17, 2007 Author Share Posted May 17, 2007 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 Link to comment Share on other sites More sharing options...
Rafita Posted November 3, 2007 Share Posted November 3, 2007 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. Link to comment Share on other sites More sharing options...
comment Posted November 3, 2007 Share Posted November 3, 2007 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/ Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6019 days old. Please don't post here. Open a new topic instead.
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 accountSign in
Already have an account? Sign in here.
Sign In Now