Page 1 of 1

Currency format with commas

Posted: Thu Jan 22, 2004 3:51 pm
by JJF
I think I'm missing something simple here.

What I want to do in my custom report is format a number as currency (i.e. with the dollar sign) and also with commas to separate thousands of dollars. E.g. $999,999.99

However, when I select the currency format, it only includes the $, not the comma(s).

What am I missing - how do I accomplish this?

Posted: Thu Jan 22, 2004 5:52 pm
by Zoe
Having this in the Format field of the expression works for me:

@$ 99,999,999.99
:D