<div>
Put the text into a field and formatted it that way, but is there a way to format the merge field?
</div>


Put the text into a field and formatted it that way, but is there a way to format the merge field?

<div>
think of merge fields as raw data, there is no formatting for raw data.<br />
an extra calculation field can change it the way you want.
</div>


think of merge fields as raw data, there is no formatting for raw data.
an extra calculation field can change it the way you want.

<div>
Thanks, this was really helpful. &nbsp;As you say, I did have other fields that I did not want formatted as currency, so went ahead with creating a field to format the info. &nbsp;Thanks.
</div>


Thanks, this was really helpful.  As you say, I did have other fields that I did not want formatted as currency, so went ahead with creating a field to format the info.  Thanks.

<div>
<div class="content wysiwyg-content">
Trying to format my merge fields for currency, but right clicking on them does not help. &nbsp;Am I going to have to create a separate field formatted for currency? &nbsp;Thank you.
</div>
</div>


Trying to format my merge fields for currency, but right clicking on them does not help.  Am I going to have to create a separate field formatted for currency?  Thank you.

FM - Formatting Merge Fields

FileMaker Pro is a cross-platform relational database application that integrates a database engine with a graphical user interface (GUI) and security features, allowing users to modify the database by dragging new elements into layouts, screens, or forms. FileMaker evolved from a DOS application, but since 1992 has been available for Microsoft Windows and Mac OS, and can be used in a cross-platform environment.