# Formatting Currency field

**URL:** https://forum.servoy.com/t/formatting-currency-field/8525
**Category:** Classic Servoy
**Created:** [December 14, 2007, 6:54am UTC](https://forum.servoy.com/t/formatting-currency-field/8525 "2007-12-14T06:54:39Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![Infop](https://avatars.discourse-cdn.com/v4/letter/i/58956e/32.png) [@Infop](https://forum.servoy.com/u/Infop)
#### Post date: [December 14, 2007, 6:54am UTC](https://forum.servoy.com/t/formatting-currency-field/8525/1 "2007-12-14T06:54:39Z")

</div>

Hi,

How can I format one Currency field.

That mean, I want to display…

$2.00  
$56.00  
$25,456.00  
$36,537,839,289.00

Then, what will be the format property for that field?

---

<div class="post-metadata">

### Author: ![rodneysieb](https://avatars.discourse-cdn.com/v4/letter/r/87869e/32.png) [@rodneysieb](https://forum.servoy.com/u/rodneysieb)
#### Post date: [December 14, 2007, 8:39am UTC](https://forum.servoy.com/t/formatting-currency-field/8525/2 "2007-12-14T08:39:26Z")

</div>

Hi

Format this as $#,##0.00

works for me.

---

<div class="post-metadata">

### Author: ![Infop](https://avatars.discourse-cdn.com/v4/letter/i/58956e/32.png) [@Infop](https://forum.servoy.com/u/Infop)
#### Post date: [December 14, 2007, 9:02am UTC](https://forum.servoy.com/t/formatting-currency-field/8525/3 "2007-12-14T09:02:38Z")

</div>

> rodneysieb:  
> Format this as $#,##0.00

Hi Rodney,

Then, you can only enter

$6,780.00  
$7,890.00  
$9,080.00

That mean, the length will be a fixed one.  
I need It can take the following numbers as well…

$2.00  
$56.45  
$25,456.00  
$36,537,839,289.35

Is it possible?

---

<div class="post-metadata">

### Author: ![Joas](https://yyz2.discourse-cdn.com/flex010/user_avatar/forum.servoy.com/joas/32/5095_2.png) [@Joas](https://forum.servoy.com/u/Joas)
#### Post date: [December 14, 2007, 9:41am UTC](https://forum.servoy.com/t/formatting-currency-field/8525/4 "2007-12-14T09:41:53Z")

</div>

Have you tried the format that Rodney suggested? Because that is the way to do it.

Further, if you want your users to enter the data with a different mask (for example to not have them type the dollar-sign and the thousand separators), you can specify that mask after a pipe like this: $#,##0.00|#.##
