Formatting money figures in CRs
Moderators: Moderators, Tech Support
-
- Posts: 320
- Joined: Sun Sep 28, 2003 5:37 pm
- Location: First Cutlerville Christian Reformed Church
- Contact:
Formatting money figures in CRs
I've written several custom reports dealing with money but cannot figure out how to get the figures edited in the right format. Dollars show up as 145000.00 instead of 145,000.00. And if I remember right using currency as the type doesn't insert commas either. Any advice for this?
-
- Tech Support
- Posts: 3014
- Joined: Thu May 13, 2004 9:59 am
- Location: PowerChurch Software
- Contact:
Re: Formatting money figures in CRs
In the Field Properties, click on the Format tab. Enter 999,999,999.99 in the Format Expression field.
-
- Posts: 320
- Joined: Sun Sep 28, 2003 5:37 pm
- Location: First Cutlerville Christian Reformed Church
- Contact:
Re: Formatting money figures in CRs
Thanks very much. That works.
-
- Posts: 4
- Joined: Wed Oct 21, 2009 3:53 pm
Re: Formatting money figures in CRs
I am seeing something similar to this when I export a report to Word '07 from powerchurch 11. How can I get the commas in my report?John Dykema wrote:I've written several custom reports dealing with money but cannot figure out how to get the figures edited in the right format. Dollars show up as 145000.00 instead of 145,000.00. And if I remember right using currency as the type doesn't insert commas either. Any advice for this?
Re: Formatting money figures in CRs
Unless the commas show up in the report as displayed, the conversion and saving of the report in Word will not include them.siempresonrisa wrote:I am seeing something similar to this when I export a report to Word '07 from powerchurch 11. How can I get the commas in my report?John Dykema wrote:I've written several custom reports dealing with money but cannot figure out how to get the figures edited in the right format. Dollars show up as 145000.00 instead of 145,000.00. And if I remember right using currency as the type doesn't insert commas either. Any advice for this?
Neil Zampella
Using PC+ since 1999.
Using PC+ since 1999.
-
- Posts: 4
- Joined: Wed Oct 21, 2009 3:53 pm
Re: Formatting money figures in CRs
NeilZ wrote:Unless the commas show up in the report as displayed, the conversion and saving of the report in Word will not include them.siempresonrisa wrote:I am seeing something similar to this when I export a report to Word '07 from powerchurch 11. How can I get the commas in my report?John Dykema wrote:I've written several custom reports dealing with money but cannot figure out how to get the figures edited in the right format. Dollars show up as 145000.00 instead of 145,000.00. And if I remember right using currency as the type doesn't insert commas either. Any advice for this?
Am I able to get the commas in the powerchurch report before exporting to Word?
Re: Formatting money figures in CRs
I don't believe so, unless you do a custom report and use the instructions given by Zorak above for formatting numbers.siempresonrisa wrote: Am I able to get the commas in the powerchurch report before exporting to Word?
Neil Zampella
Using PC+ since 1999.
Using PC+ since 1999.