Formatting Currency field

[Infop]

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?

[rodneysieb]

Hi

Format this as $#,##0.00

works for me.

[Infop]

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?

[Joas]

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|#.##