# Suppport to display correct number format for non US integer and or currency

**URL:** https://discuss.elastic.co/t/suppport-to-display-correct-number-format-for-non-us-integer-and-or-currency/220807
**Category:** Kibana
**Created:** [February 25, 2020, 9:44am UTC](https://discuss.elastic.co/t/suppport-to-display-correct-number-format-for-non-us-integer-and-or-currency/220807 "2020-02-25T09:44:00Z")
**Posts on this page:** 6
**Page:** 1

<div class="post-metadata">

### Author: ![Datakids](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/datakids/32/39622_2.png) [@Datakids](https://discuss.elastic.co/u/Datakids)
#### Post date: [February 25, 2020, 9:44am UTC](https://discuss.elastic.co/t/suppport-to-display-correct-number-format-for-non-us-integer-and-or-currency/220807/1 "2020-02-25T09:44:01Z")

</div>

Hi there,

I still messing arround with the correct number format for non US nummeric and or currency fields like:  
0,01  
1,00  
10,00  
100,00  
1.000,00  
10.000,00  
100.000,00  
1.000.000,00  
10.000.000,00  
are they still not supported or possible in Kibana or do I overseen somewhat?

Thanks for any reply  
Regards

---

<div class="post-metadata">

### Author: ![joshdover](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/joshdover/32/42020_2.png) [@joshdover](https://discuss.elastic.co/u/joshdover)
#### Post date: [February 25, 2020, 6:08pm UTC](https://discuss.elastic.co/t/suppport-to-display-correct-number-format-for-non-us-integer-and-or-currency/220807/2 "2020-02-25T18:08:59Z")

</div>

Hi!

Have you tried setting the `format:currency:defaultPattern` and `format:number:defaultLocale` setting in Management? When I use a [numeral locale](https://github.com/adamwdraper/Numeral-js/tree/master/locales) with the correct delimiters (eg. 'it') and then set the pattern to `0,0.00` it appears to work.

Let me know if this works for you!

---

<div class="post-metadata">

### Author: ![Datakids](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/datakids/32/39622_2.png) [@Datakids](https://discuss.elastic.co/u/Datakids)
#### Post date: [February 27, 2020, 8:53am UTC](https://discuss.elastic.co/t/suppport-to-display-correct-number-format-for-non-us-integer-and-or-currency/220807/3 "2020-02-27T08:53:35Z")

</div>

Hi Josh,  
yes it works but it is not what I expect!  
If I use your pattern it looks: 2,340.06  
What I want is: 2.340,06  
So the pattern 0.0,00 is not supported!

The most common and applied pattern is not supported  
What I wanna know is why and when ?

---

<div class="post-metadata">

### Author: ![joshdover](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/joshdover/32/42020_2.png) [@joshdover](https://discuss.elastic.co/u/joshdover)
#### Post date: [February 27, 2020, 6:42pm UTC](https://discuss.elastic.co/t/suppport-to-display-correct-number-format-for-non-us-integer-and-or-currency/220807/4 "2020-02-27T18:42:21Z")

</div>

> [@Datakids](#):
>
> 0.0,00

The format I used was not this one, it should be `0,0.00` when the locale is set to `it`

---

<div class="post-metadata">

### Author: ![Datakids](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/datakids/32/39622_2.png) [@Datakids](https://discuss.elastic.co/u/Datakids)
#### Post date: [February 28, 2020, 9:51am UTC](https://discuss.elastic.co/t/suppport-to-display-correct-number-format-for-non-us-integer-and-or-currency/220807/5 "2020-02-28T09:51:23Z")

</div>

Hi,  
yes it works! Thanks

I think the problem is that Kibana use the common standard german thousends delimiter known as a blank character.

But this will not applied by the most applications and makes no sense anyway.  
In daily works nobody use a blank char to display thousends for currency or numbers.  
(At least I don't know anybody who does that, and even I never haven't met anybody or saw that in applications or reports!)

In fact:  
to manage 99% of all usecases we just need 2 patterns to make it easy to read:  
0,0.00 or 0.0,00 no matter what locale is set.

Have a sunny day  
Regards

---

<div class="post-metadata">

### Author: ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)
#### Post date: [March 27, 2020, 9:51am UTC](https://discuss.elastic.co/t/suppport-to-display-correct-number-format-for-non-us-integer-and-or-currency/220807/6 "2020-03-27T09:51:25Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.
