Format Number

[Tom England]

I have found that if I have a layout, a letter for example, with a percentage figure MERGED within the text, I can highlight the WHOLE text, and format number into a percentage. The problem is that any other numbers merged then become percentages.

I have tried inserting a field rather than merging, but as is Filemakers want, it lines up nowhere near the possition I wnt it.

Can anyone help??

[rdhaden]

Instead of having one block of text containing both number types, break the text up into more than one block.

[DykstrL]

formatting merge fields this way also works for numbers,text,and time. The drawback is, you can only have one defined format for each type for that text block.

The work-around is as 'rdhaden' posted: break up the text into more that one text block, i.e., have each number merge field contained in separate text blocks.

[Thom]

My suggestion would be to create a calc field that returns a formatted percent as text, then merge that. For example:

numAsPercent(calc,text) = number * 100 & "%"

[AndriesV]

Is the formatting of merge fields as describled above a feature of FM5 only, I could really make good use of this but can't figure out how to do this in FM4 (The company won't upgrate (yet) to FM5), I only see the option for changing the text properties of the mergefield.

Thanks for any suggestions.

[Steven H. Blackwell]

quote:

---

Originally posted by AndriesV:

Is the formatting of merge fields as describled above a feature of FM5 only, I could really make good use of this but can't figure out how to do this in FM4 (The company won't upgrate (yet) to FM5), I only see the option for changing the text properties of the mergefield.

Thanks for any suggestions.

---

Just a brief note:

Upgrades to FileMaker Pro 5 are no longer available. FileMaker Pro 5.5 is the current version. FileMaker, Inc. is offering a special price on FIleMAker Pro 5.5 and FileMaker Server 5.5 until mid-December. Details on their web site.

HTH

Old Advance Man

[AndriesV]

Thanks for the reply.

Does someone have the answer to my question whether this number formating of text blocks is a feature of FM5(.5) only or whether I'm missing something that is available in FM4.

Thank in advance

[Thom]

You change the number format of the text object as a whole, not just the merge code. In FM4 the number format is not available by right-clicking; you have to choose Format from the menu.

[AndriesV]

Thanks that solved it