CiviCRM Community Forums (archive)

In the documentation for Settings - Localization, it states:

'Monetary Display - Enter the format for displaying monetary values, i.e. "%c %a"'

I haven't found any documentation on what values, such as %c or %a, are to be used if I want to vary this.

In my case, the default for USD currency is something like $25000.00

and I would like to make it $25,000

I assume that if I understood what the basis was for the %c and %a format strings, I could make this change.

What are the format rules for this field?

There is only one choice for the Monetary Locale setting: en_US.  In the documentation for "CiviCRM Localisation," it states "The amount of 1234567 dollars and 89 cents will be displayed as '1,234,567.89' with an 'en_US' locale" but my CiviCRM installation (1.9) displays dollars and cents like '1234567.89' that is, without the commas.  I tried to test this on the 2.0 demo system, but the demo account does not have access to civicontributions, so I can't test to see if this is fixed on 2.0.

Am I missing something on how to configure this locale setting so I see the commas?

If I want to remove the "cents" part, where would I go to customize this formatting?

I set up a simple page in Drupal to test this.  First, I used what you suggested, based on what was in CRM/Utils/Money.php

<?php
 if ( function_exists( 'money_format' ) ) {
print (money_format('%!i', 10000));
} else {print("no money_format");}
?>

and I got
10000.00

I wanted to get rid of the digits to the right of the decimal, so I tried the following:

<?php
 if ( function_exists( 'money_format' ) ) {
print (money_format('%!.0i', 10000));
} else {print("no money_format");}
?>

and the result was
10000

Then I added the setlocale() call:

<?php
 if ( function_exists( 'money_format' ) ) {
setlocale(LC_MONETARY, 'en_US');
print (money_format('%!.0i', 10000));
} else {print("no money_format");}
?>

and now I get
10,000

I don't know where you call setlocale() but it seems to be missing from my implementation.

Unless it changed, the Monetary Display option only allows %a, %c and %C which don't do what I need.  I would be *MUCH* happier if I could put something like %!.0i in this field so I don't have to change CiviCRM.

Fixed on trunk, so will be an option in CiviCRM 2.1.