Answers.Body: <p>The crmMoney function uses php's money_format() function to format the numbers. On Windows, this function does not exist! (<a href="https://issues.civicrm.org/jira/browse/CRM-650" rel="nofollow noreferrer">https://issues.civicrm.org/jira/browse/CRM-650</a>)</p>
  
  <p>However you can use crmNumberFormat to format it yourself, and add in the currency symbol manually, for example, assuming you want the US dollar symbol:</p>
  
  <p>Instead of <code>{$amount|crmMoney:$currency}</code>, use</p>
  
  <p><code>${$amount|crmNumberFormat:2}</code></p>
  
  <p>Note the extra $ at the beginning, which outputs the literal dollar sign. The above will also use the separator and decimal point characters you have set up on the admin screen.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-03-28T03:11:51.827Z
Answers.Text: This works for the invoice, thank you so much for the explanation and answer! Additional question, what is the best environment to run CIVICRM, if it's not windows?
Answers.UserDisplayName: Jennifer Lee
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-03-28T03:21:32.047Z
Answers.Text: Windows is normally fine, but all the developers seem to have macs for some reason, but that's a whole other topic. The main test environment that the offical tests run on is debian and ubuntu linux.
Answers.UserDisplayName: Demerit
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-03-28T11:37:15.863Z
Answers.Text: another solution http://blog.nirvan.pagooah.com/fixing-undefined-function-money_format-in-windows/ but I havn't tried, I will comment again if this works
Answers.UserDisplayName: Jennifer Lee
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-03-27T12:19:16.647Z
Answers.LastActivityDate: 2019-03-27T12:19:16.647Z
Answers.UserDisplayName: Demerit
Answers.Body: <p>If you need to change the settings globally, not just for the single statement, you have the option under Administer -> Localization -> Languages, Currency, Locations. There you can define the "Thousands Separator" as well as the "Decimal Delimiter".</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-03-22T08:44:58.747Z
Answers.LastActivityDate: 2019-03-22T08:44:58.747Z
Answers.UserDisplayName: Joachim
Answers.Body: <p><a href="https://i.sstatic.net/01ijP.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/01ijP.png" alt="enter image description here"></a></p>
  
  <p>Joachim, it's like this by default, the thousand separator doesn't work also in Individual> Contribution.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-03-22T09:03:12.863Z
Answers.Text: The settings look all just like mine. I just checked this in my Civi test installation (version 7.11.0 with Wordpress 5.1) by trying to use the "=" character as a thousands separator - and it worked for screen displays of currency amounts as well as in the printed invoice. Therefore, I assume something else is interfering here. Perhaps there are some customizations in your code/template or some extension may influence this?
Answers.UserDisplayName: Joachim
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-03-22T09:08:04.303Z
Answers.Text: Maybe it's because i used CIVI 5.1.1 Joomla 3.9.4 , i don't modify codes too much as I'm not sure how they work, never install any templates too, and thank you for helping btw :)
Answers.UserDisplayName: Jennifer Lee
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-03-22T09:10:47.503Z
Answers.Text: Oh, I made typo - it's of course version 5.11.0.
Answers.UserDisplayName: Joachim
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-01-23T19:17:24.193Z
Answers.Text: Is there any update on this? Is there a way to get the thousands delimiter to work?
Answers.UserDisplayName: menachem
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-03-22T08:54:24.810Z
Answers.LastActivityDate: 2019-03-22T08:54:24.810Z
Answers.UserDisplayName: Jennifer Lee
Body: <p>I'm not really good in any sorts of programing, haven't used smarty before. I want to <strong>change the monetary format in our Invoice</strong>.</p>
  
  <pre><code>{$amount|crmMoney:$currency}
  </code></pre>
  
  <p>This code displays $1000.00, but I need $1,000.00 or $1,000 , how can I achieve this?</p>
  
  <p>my civicrm version is 5.1.1, joomla 3.9.4, CRM runs in Window 7
  <br/><br/></p>
  
  <p>updates: <br/>
  1. thanks to Joachim I notice decimal is working fine, thousand separators is not, whatever I input in Localization Currency> Thousand Separator, nothing displays.
  <br/><br/>
  2. upgraded Civicrm to 5.11.0, problem persist.
  <br/><br/>
  3. the problem is not in {$amount|crmMoney:$currency} or MONEY.php, I think something's wrong with my settings.</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-03-26T12:34:45.277Z
Comments.Text: Is your server on windows?
Comments.UserDisplayName: Demerit
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-03-27T04:24:59.223Z
Comments.Text: Yes, it's win 7
Comments.UserDisplayName: Jennifer Lee
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-03-27T12:13:08.753Z
Comments.Text: Ok I will post an answer.
Comments.UserDisplayName: Demerit
Tags: <joomla><contributions><invoice><display><currency>
Title: Invoice Monetary Format
ThreadText: # Invoice Monetary Format
  
  (Asked by: username_0 on 2019-03-22)
  
  I'm not really good in any sorts of programing, haven't used smarty before. I want to **change the monetary format in our Invoice**.
  
  ```
  {$amount|crmMoney:$currency}
  
  ```
  
  This code displays $1000.00, but I need $1,000.00 or $1,000 , how can I achieve this?
  
  my civicrm version is 5.1.1, joomla 3.9.4, CRM runs in Window 7
  
  updates:   
  1. thanks to username_2 I notice decimal is working fine, thousand separators is not, whatever I input in Localization Currency> Thousand Separator, nothing displays.
    
    
  2. upgraded Civicrm to 5.11.0, problem persist.
    
    
  3. the problem is not in {$amount|crmMoney:$currency} or MONEY.php, I think something's wrong with my settings.
  
  **Tags:** joomla, contributions, invoice, display, currency
  
  > **Comments:**
  > **username_1**: Is your server on windows?  
  > **username_0**: Yes, it's win 7  
  > **username_1**: Ok I will post an answer.  
  
  ---
  
  ## 3 answers
  
  ### Answer by username_1 on 2019-03-27. Score: 2 | Accepted answer
  
  The crmMoney function uses php's money\_format() function to format the numbers. On Windows, this function does not exist! (<https://issues.civicrm.org/jira/browse/CRM-650>)
  
  However you can use crmNumberFormat to format it yourself, and add in the currency symbol manually, for example, assuming you want the US dollar symbol:
  
  Instead of `{$amount|crmMoney:$currency}`, use
  
  `${$amount|crmNumberFormat:2}`
  
  Note the extra $ at the beginning, which outputs the literal dollar sign. The above will also use the separator and decimal point characters you have set up on the admin screen.
  
  > **Comments:**
  > **username_0**: This works for the invoice, thank you so much for the explanation and answer! Additional question, what is the best environment to run CIVICRM, if it's not windows?  
  > **username_1**: Windows is normally fine, but all the developers seem to have macs for some reason, but that's a whole other topic. The main test environment that the offical tests run on is debian and ubuntu linux.  
  > **username_0**: another solution http://blog.nirvan.pagooah.com/fixing-undefined-function-money_format-in-windows/ but I havn't tried, I will comment again if this works  
  
  ---
  
  ### Answer by username_2 on 2019-03-22. Score: 2
  
  If you need to change the settings globally, not just for the single statement, you have the option under Administer -> Localization -> Languages, Currency, Locations. There you can define the "Thousands Separator" as well as the "Decimal Delimiter".
  
  
  ---
  
  ### Answer by username_0 on 2019-03-22. Score: 0
  
  [![enter image description here](https://i.sstatic.net/01ijP.png)](https://i.sstatic.net/01ijP.png)
  
  username_2, it's like this by default, the thousand separator doesn't work also in Individual> Contribution.
  
  > **Comments:**
  > **username_2**: The settings look all just like mine. I just checked this in my Civi test installation (version 7.11.0 with Wordpress 5.1) by trying to use the "=" character as a thousands separator - and it worked for screen displays of currency amounts as well as in the printed invoice. Therefore, I assume something else is interfering here. Perhaps there are some customizations in your code/template or some extension may influence this?  
  > **username_0**: Maybe it's because i used CIVI 5.1.1 Joomla 3.9.4 , i don't modify codes too much as I'm not sure how they work, never install any templates too, and thank you for helping btw :)  
  > **username_2**: Oh, I made typo - it's of course version 5.11.0.  
  > **username_3**: Is there any update on this? Is there a way to get the thousands delimiter to work?  
  
  ---
  
  