# Currency Format **URL:** \ **Category:** Kibana\ **Created:** [December 8, 2020, 1:23pm UTC](https://discuss.elastic.co/t/currency-format/257999 "2020-12-08T13:23:30Z")\ **Posts on this page:** 11\ **Page:** 1
**Author:** ![hzarrabi](https://avatars.discourse-cdn.com/v4/letter/h/f9ae1b/32.png) [@hzarrabi](https://discuss.elastic.co/u/hzarrabi)\ **Post date:** [December 8, 2020, 1:23pm UTC](https://discuss.elastic.co/t/currency-format/257999/1 "2020-12-08T13:23:30Z")
Hi all, My data in Elasticsearch index are numbers (integer, long, float) and amounts in euros € currency whitout affecting those are just a number. I would like to display all amounts with euro € signe. Unfortunately, any formating in Kibana -\> advanced settings -\> Currency format does not help. If I do this formating in Kibana -\> advanced settings -\> Number format, it would apply changes on all other numbers that are not currency. Do you have any solution please ? Best regards ---
**Author:** ![ylasri](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ylasri/32/86120_2.png) [@ylasri](https://discuss.elastic.co/u/ylasri)\ **Post date:** [December 8, 2020, 2:02pm UTC](https://discuss.elastic.co/t/currency-format/257999/2 "2020-12-08T14:02:26Z")
Under Management \> Index Patterns you can specify a field formatter per field. The number formatter uses [numeraljs](http://numeraljs.com/) for formattering numbers. Checkout out their docs. ---
**Author:** ![hzarrabi](https://avatars.discourse-cdn.com/v4/letter/h/f9ae1b/32.png) [@hzarrabi](https://discuss.elastic.co/u/hzarrabi)\ **Post date:** [December 8, 2020, 3:15pm UTC](https://discuss.elastic.co/t/currency-format/257999/3 "2020-12-08T15:15:07Z")
Hi ylasri. Thank you for replaying. Indeed, there is this option in **Advanced Setting** as I mentioned in my post. The problème is that, I have both numbers (which are notre currency money) and numbers which are currency. As ex : **5** plane tickets each **500 €** and the sum would be **2500 €** If I format in the advanced setting the **Currency format** as (0,0.[00]€), it does not affect the currency because all my currency fields are numbers. And at the same time if change my **Number format** from 0,0.[000] into (0,0.[00]€) all my numbers will be displayed as currency. So the Advanced Setting could not solve my problème ! Any Idea ? Best Regards ---
**Author:** ![ylasri](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ylasri/32/86120_2.png) [@ylasri](https://discuss.elastic.co/u/ylasri)\ **Post date:** [December 8, 2020, 3:30pm UTC](https://discuss.elastic.co/t/currency-format/257999/4 "2020-12-08T15:30:49Z")
The **Advanced Setting** will be applied to any field with type number I suggested to define the number format on each index patten/field, so there you will able to apply the formmatting to the specific field you want. ---
**Author:** ![hzarrabi](https://avatars.discourse-cdn.com/v4/letter/h/f9ae1b/32.png) [@hzarrabi](https://discuss.elastic.co/u/hzarrabi)\ **Post date:** [December 8, 2020, 3:36pm UTC](https://discuss.elastic.co/t/currency-format/257999/5 "2020-12-08T15:36:50Z")
Thank you so much. I just found it this solution. It's to much work but better then nothing Regards ---
**Author:** ![ylasri](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ylasri/32/86120_2.png) [@ylasri](https://discuss.elastic.co/u/ylasri)\ **Post date:** [December 8, 2020, 3:38pm UTC](https://discuss.elastic.co/t/currency-format/257999/6 "2020-12-08T15:38:59Z")
Yes, you need to do that for each field 🙂 You are limited by possibilities offered by [numeraljs](http://numeraljs.com/) ---
**Author:** ![hzarrabi](https://avatars.discourse-cdn.com/v4/letter/h/f9ae1b/32.png) [@hzarrabi](https://discuss.elastic.co/u/hzarrabi)\ **Post date:** [December 8, 2020, 3:40pm UTC](https://discuss.elastic.co/t/currency-format/257999/7 "2020-12-08T15:40:58Z")
Is there any template mapping that could do the job ? ---
**Author:** ![ylasri](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ylasri/32/86120_2.png) [@ylasri](https://discuss.elastic.co/u/ylasri)\ **Post date:** [December 8, 2020, 3:42pm UTC](https://discuss.elastic.co/t/currency-format/257999/8 "2020-12-08T15:42:21Z")
Not sure if this is possible from the mapping perspective in elasticsearch It's more related to Kibana API to define the index pattern and its properties ---
**Author:** ![hzarrabi](https://avatars.discourse-cdn.com/v4/letter/h/f9ae1b/32.png) [@hzarrabi](https://discuss.elastic.co/u/hzarrabi)\ **Post date:** [December 8, 2020, 3:44pm UTC](https://discuss.elastic.co/t/currency-format/257999/9 "2020-12-08T15:44:43Z")
I mean as a type of field like currency. I know there isn't one, but it might be helpful if Elastic introduced it. ---
**Author:** ![hzarrabi](https://avatars.discourse-cdn.com/v4/letter/h/f9ae1b/32.png) [@hzarrabi](https://discuss.elastic.co/u/hzarrabi)\ **Post date:** [December 8, 2020, 4:23pm UTC](https://discuss.elastic.co/t/currency-format/257999/10 "2020-12-08T16:23:48Z")
This is for those who have encountered the same problem. In Kibana, you have to go to **Index Patterns** then choose the index in which you want to apply the currency format then edit the selected field and modify its display format as in the image. ![Currency Formatting](https://us1.discourse-cdn.com/elastic/original/3X/b/a/bab6a042cfae247d46e5e3775eae60b30564ede1.png) ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [January 5, 2021, 4:23pm UTC](https://discuss.elastic.co/t/currency-format/257999/11 "2021-01-05T16:23:51Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.