You could format the merged field by selecting it and by appling the same rules to the number format.
BTW: remember that ALL the other numbers of the SAME merged text will have the same formatting.
thanks for your reply and help, to be honest its a little confusing.
You can't format a merged fields in a layout ..? <<AmountOustanding>> etc
I assume its taking the formatting from the original field. Which are all working perfectly on other field layouts.
Yes, you can format the merged text.
While in Layout Mode, select the merged text by clicking on it.
a merged field acts like text and sits within the body of text it is not a 'clickable' field. see example below...
e.g Dear <<Salution>> <<FirstName>> <<Surname>> so in layout mode it only can be formatted as text e.g size, font etc.
when you go to browse mode it searches for the data from the relelvant fields. Maybe you are thinking i'm placing fields into the layout, i'm not.
Thank you for your beautifull lesson... but I think that you are wrong: in layout mode the merged field CAN be selected by clicking on it !!
As I said before, the choosen formatting will apply to ALL the merged text.
Massive apologies, i understand now what you mean. The problem i now have is that it data formats all of the merged fields on the layout and not just individuals one.
ie. some are currency merged fields and some are just txt merged field but i can select individual merged fields.
You must have no problem if the number fields of the merged text are all currency; problems can occur if the merged text contains even other number fields ( like quantity ) that do not have to be formatted.
Hello. I'm having this same problem. I read this post and tried to click on the merge field to format it to currency but the only option I get it formatting the text. I have Filemaker Pro 10 and am using it on my Mac OS X v 10.6.8.
Am I missing something? When in browse mode in my table, all amounts have the correct formatting (1000 looks like 1,000 which is what I want, the comma). However in my mail merge document it still shows up as 1000 without the comma.
The fields I'm using have a calculation involved (10% of the total amount).
Any help would be greatly appreciated!
Oh my goodness. I just figured this out. Click the whole "text box" which includes all verbiage in as well as mail merge fields in the form letter and then go to format, choose number, etc...