Community
Showing results for 
Search instead for 
Do you mean 
Reply

Currency sign $ not showing up in report, why?

Accepted Solution Solved
Astute Commentator
Posts: 77
Country: USA
Accepted Solution

Currency sign $ not showing up in report, why?

I have a field that is defined as a currency. It shows up like this in act $157,215 but in my report it shows up as 157215. What do I do in the report to change the appearance to look like it does in ACT?

 

Thanks


Accepted Solutions
Solution
Accepted by topic author epalanb
‎09-25-2015 03:20 AM
Platinum Elite Contributor
Posts: 6,652
Country: USA

Re: Currency sign $ not showing up in report, why?

Right click on the field, select properties and change the format to currency.

Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129

View solution in original post


All Replies
Solution
Accepted by topic author epalanb
‎09-25-2015 03:20 AM
Platinum Elite Contributor
Posts: 6,652
Country: USA

Re: Currency sign $ not showing up in report, why?

Right click on the field, select properties and change the format to currency.

Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129
Astute Commentator
Posts: 77
Country: USA

Re: Currency sign $ not showing up in report, why?

Thanks,

Works just like you said it would.

Copper Contributor
Posts: 19
Country: USA

Re: Currency sign $ not showing up in report, why?

Do you know how to remove the cents? I only want whole dollars. The cents are not material to our business, but beyond that, those character spaces eat up valuable real estate and distract from overall readability.

 

Thanks

Platinum Elite Contributor
Posts: 6,652
Country: USA

Re: Currency sign $ not showing up in report, why?

Unless you change your Windows default you would need to use a custom field nad a VB program script to eliminated the decimals.

Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129
Copper Contributor
Posts: 19
Country: USA

Re: Currency sign $ not showing up in report, why?

Thanks Roy. At least I know to stop looking at this point. That seems to be a program deficiency to me. We buy and use Act because it's generally easier than getting into all that, while still being powerful.