# Displaying number

**URL:** <https://discuss.elastic.co/t/displaying-number/307091>\
**Category:** Kibana\
**Created:** [June 14, 2022, 5:03am UTC](https://discuss.elastic.co/t/displaying-number/307091 "2022-06-14T05:03:04Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![behappy\_alwayz0401](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/behappy_alwayz0401/32/105988_2.png) [@behappy\_alwayz0401](https://discuss.elastic.co/u/behappy_alwayz0401)\
**Post date:** [June 14, 2022, 5:03am UTC](https://discuss.elastic.co/t/displaying-number/307091/1 "2022-06-14T05:03:04Z")

</div>

Hi,  
is there a way to store a number as 0,0a format but for report download purposes it still shows as the full number? The reason being, when you download the 0,0a format to a CSV it doesnt show up as a number for further use.  
e.g. 100,000 stores as 100k and downloads as 100k in CSV as well and not as a number and cannot be converted to number format in CSV. thanks  
screenshot of Discover report download  
 ![image](https://us1.discourse-cdn.com/elastic/original/3X/a/4/a49e188a63228708a108c17fa5f1aa858a45cdb8.png)

---

<div class="post-metadata">

**Author:** ![Stratoula\_Kalafateli](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/stratoula_kalafateli/32/70923_2.png) [@Stratoula\_Kalafateli](https://discuss.elastic.co/u/Stratoula_Kalafateli)\
**Post date:** [June 14, 2022, 7:24am UTC](https://discuss.elastic.co/t/displaying-number/307091/2 "2022-06-14T07:24:31Z")

</div>

I don't think that this is something you can do in general. The csv in general downloads the fields with the exact format that you see on your browser.

---

<div class="post-metadata">

**Author:** ![behappy\_alwayz0401](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/behappy_alwayz0401/32/105988_2.png) [@behappy\_alwayz0401](https://discuss.elastic.co/u/behappy_alwayz0401)\
**Post date:** [June 14, 2022, 9:37am UTC](https://discuss.elastic.co/t/displaying-number/307091/3 "2022-06-14T09:37:35Z")

</div>

Would there be any workaround to this... so we can display as 100k but download as 100,000 to CSV?

---

<div class="post-metadata">

**Author:** ![behappy\_alwayz0401](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/behappy_alwayz0401/32/105988_2.png) [@behappy\_alwayz0401](https://discuss.elastic.co/u/behappy_alwayz0401)\
**Post date:** [June 14, 2022, 1:00pm UTC](https://discuss.elastic.co/t/displaying-number/307091/4 "2022-06-14T13:00:50Z")

</div>

And if no workaround is available currently, how can one place this as a feature request? We often use report downloads and to make calculations on the downloaded data. For viewing purposes on Kibana, displaying as 0,0a is required but without that coming in the way of calculations on a CSV download.. thanks..

---

<div class="post-metadata">

**Author:** ![Stratoula\_Kalafateli](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/stratoula_kalafateli/32/70923_2.png) [@Stratoula\_Kalafateli](https://discuss.elastic.co/u/Stratoula_Kalafateli)\
**Post date:** [June 15, 2022, 3:29pm UTC](https://discuss.elastic.co/t/displaying-number/307091/5 "2022-06-15T15:29:16Z")

</div>

Actually what you can do is go to Inspect and select download CSV as raw value  
For example in Lens

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/9/1/91d6505db3afb21e6acdc505040891efde20d22c.png)

this will download the CSV without the formatters.

---

<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:** [July 13, 2022, 3:29pm UTC](https://discuss.elastic.co/t/displaying-number/307091/6 "2022-07-13T15:29:33Z")

</div>

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