# How to display thousands separators and decimals in the Italian format?

**URL:** <https://community.eazybi.com/t/how-to-display-thousands-separators-and-decimals-in-the-italian-format/16844>\
**Category:** Questions & Answers\
**Created:** [April 9, 2024, 8:16am UTC](https://community.eazybi.com/t/how-to-display-thousands-separators-and-decimals-in-the-italian-format/16844 "2024-04-09T08:16:30Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![kalos](https://community.eazybi.com/user_avatar/community.eazybi.com/kalos/32/14132_2.png) [@kalos](https://community.eazybi.com/u/kalos)\
**Post date:** [April 9, 2024, 8:16am UTC](https://community.eazybi.com/t/how-to-display-thousands-separators-and-decimals-in-the-italian-format/16844/1 "2024-04-09T08:16:31Z")

</div>

Hello everyone, I am trying to understand how to display the separator of thousands and decimals in the Italian format. Currently the comma is used to separate the thousands. I am using a “measure” that calculates the number of working days from the total number of hours divided by “8”.

![Screenshot 2024-04-09 alle 10.14.15](https://community.eazybi.com/uploads/default/original/2X/a/ad036782d4d61ea8cc274ff278d81a3ae2911653.png)

---

<div class="post-metadata">

**Author:** ![nauris.malitis](https://community.eazybi.com/user_avatar/community.eazybi.com/nauris.malitis/32/6355_2.png) [@nauris.malitis](https://community.eazybi.com/u/nauris.malitis)\
**Post date:** [April 17, 2024, 1:34pm UTC](https://community.eazybi.com/t/how-to-display-thousands-separators-and-decimals-in-the-italian-format/16844/2 "2024-04-17T13:34:38Z")

</div>

Hi @kalos

I see that you already found a Community post referencing custom locales: [Number format from 1,234.56 to 1.234,56 - #2 by gerda.grantina](https://community.eazybi.com/t/number-format-from-1-234-56-to-1-234-56/8971/2)

In the documentation page, you’ll find that you can create your own custom locales file: [Custom locales](https://docs.eazybi.com/eazybi/set-up-and-administer/customization/custom-locales#Customlocales-AddacustomlocaletoaJirainstance)

ChatGPT returned the following possible settings for Italian locale:

```toml
it:
  locales:
    xx: "Ora Italiana"

xx:
  cubes:
    dimensions:
      Time:
        caption: "Tempo"
        all_member_caption: "Tutto il Tempo"
        Year:
          caption: "Anno"
          member_format: "%Y"
        Quarter:
          caption: "Trimestre"
          member_format: "T%{key} %Y"
        Month:
          caption: "Mese"
          member_format: "%Y/%m"
        Day:
          caption: "Giorno"
          member_format: "%d/%m/%Y"
        Weekly:
          caption: "Settimanale"
          all_member_caption: "Tutto il Tempo (settimanale)"
          Year:
            caption: "Anno"
            member_format: "%Y"
          Week:
            caption: "Settimana"
            member_format: "S%{key}, %d/%m/%Y"
          Day:
            caption: "Giorno"
            member_format: "%d/%m/%Y"
        Fiscal:
          all_member_caption: "Tutti i periodi fiscali"
          caption: "Fiscale"
          Year:
            caption: "Anno"
            member_format: "EF%{key}"
          Quarter:
            caption: "Trimestre"
            member_format: "EF%{parent_key} T%{key}"
          Month:
            caption: "Mese"
            member_format: "EF%Y/%m"
          Day:
            caption: "Giorno"
            member_format: "%d/%m/%Y"
        "2 Weeks":
          caption: "Bi-settimanale"
          all_member_caption: "Tutto il Tempo (bi-settimanale)"
          Year:
            caption: "Anno"
            member_format: "%Y"
          Weeks:
            caption: "Settimane"
            member_format: "S%{key}, %d/%m/%Y"
          Day:
            caption: "Giorno"
            member_format: "%d/%m/%Y"

  date:
    formats:
      default: "%Y-%m-%d"
      long: "%d %B %Y"
      short: "%d %b %Y"
      month_year: "%B %Y"
      month_year_short: "%b %Y"
      month_day_short: "%d %b"

  time:
    formats:
      default: "%a, %d %b %Y %H:%M:%S %z"
      long: "%d %B %Y %H:%M:%S"
      short: "%d %b %Y %H:%M:%S"

  number:
    format:
      delimiter: "."
      precision: 2
      separator: ","
      significant: false
      strip_insignificant_zeros: false

```

Please, double-check before implementing.  
I hope that this leads to the right direction!  
​Best regards,  
​Nauris
