How to Change Currency Formatting (Decimal and Thousand Separators)

When working with multiple currencies, it’s often necessary to adjust how numbers and amounts are displayed – for example, whether the system should use a comma or a dot as the decimal separator.

This guide explains how to change the decimal separator and thousand separator for your currencies.

🔧 Step-by-Step

1. Go to Settings → Administration → Currencies

2. Click on the currency you want to edit (e.g. Denmark, Kroner)

3. Adjust the following fields:

   • Decimal Separator → defines the character between units and decimals (e.g. , or .)

   • Thousand Grouping Separator → defines the character between thousands (e.g. . or ,)

   • Thousand Grouping Pattern → defines how numbers are grouped (e.g. 123,456,789)

   • Symbol Placement → choose whether the currency symbol appears before or after the amount ($1.0 or 1.0$)

   • Currency Decimals → select how many decimals to show (typically 2)

   • Remove Trailing Zeros → choose Yes to remove unnecessary decimals (e.g. 100 instead of 100.00)

4. Click Save to apply the changes.

💡 Example

If you want the Danish style (e.g. 1.234,56 kr), use:

• Decimal Separator: ,

• Thousand Separator: .

• Symbol Placement: $1.0

💬 Your currency values will now appear correctly formatted – making your reports and invoices look consistent and professional.