Currency format with commas

Moderators: Moderators, Tech Support

Post Reply
JJF
Posts: 1
Joined: Thu Jan 22, 2004 3:38 pm
Location: Zion Baptist Community Church

Currency format with commas

Post 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?

Zoe
Tech Support
Tech Support
Posts: 58
Joined: Tue Sep 02, 2003 12:08 pm
Location: PowerChurch Software
Contact:

Post by Zoe »

Having this in the Format field of the expression works for me:

@$ 99,999,999.99
:D
PowerChurch Software Technical Support

Post Reply