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?
Hi
Format this as $#,##0.00
works for me.
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?
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|#.##