# Formatting a merge field

**URL:** https://forum.servoy.com/t/formatting-a-merge-field/4012
**Category:** Classic Servoy
**Created:** [April 11, 2005, 7:46am UTC](https://forum.servoy.com/t/formatting-a-merge-field/4012 "2005-04-11T07:46:06Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![Neale](https://avatars.discourse-cdn.com/v4/letter/n/7ab992/32.png) [@Neale](https://forum.servoy.com/u/Neale)
#### Post date: [April 11, 2005, 7:46am UTC](https://forum.servoy.com/t/formatting-a-merge-field/4012/1 "2005-04-11T07:46:06Z")

</div>

Merging fields into letters (which are RTF in the DB) is working just fine, but now I have a small challenge:

How do I format a number field as currency? I.e. with a numeric value in the DB of say 45.3 I need that to appear as “$45.30” (currently it’s “45.3”.) - i.e. like using field formatting of “$#,##0.00”.

How do I do this?

Thanks,  
Neale.

---

<div class="post-metadata">

### Author: ![Backer](https://avatars.discourse-cdn.com/v4/letter/b/4491bb/32.png) [@Backer](https://forum.servoy.com/u/Backer)
#### Post date: [April 12, 2005, 10:40am UTC](https://forum.servoy.com/t/formatting-a-merge-field/4012/2 "2005-04-12T10:40:08Z")

</div>

In the field property set the format value to “#.00” from the dropdown. This will diaplay a numeric value as currency.

---

<div class="post-metadata">

### Author: ![Jan\_Blok](https://avatars.discourse-cdn.com/v4/letter/j/41988e/32.png) [@Jan\_Blok](https://forum.servoy.com/u/Jan_Blok)
#### Post date: [April 20, 2005, 2:28pm UTC](https://forum.servoy.com/t/formatting-a-merge-field/4012/3 "2005-04-20T14:28:24Z")

</div>

> Neale:  
> How do I do this?

Make a calculation using utils.numberFormat(…)