# Number in 0,0a format downloading as text in CSV **URL:** \ **Category:** Kibana\ **Created:** [June 15, 2022, 5:21am UTC](https://discuss.elastic.co/t/number-in-0-0a-format-downloading-as-text-in-csv/307216 "2022-06-15T05:21:19Z")\ **Posts on this page:** 6\ **Page:** 1
**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 15, 2022, 5:21am UTC](https://discuss.elastic.co/t/number-in-0-0a-format-downloading-as-text-in-csv/307216/1 "2022-06-15T05:21:19Z")
Hi, this is an important feature request. We observe that Kibana gives the user the flexibility to display number in the format as 100k rather than 100,000. However, when a report of such kind is downloaded to CSV, the number 100k shows up as text which renders it without use for further calculations. We often download reports from Kibana for further use. In this post, we were informed that this is currently not possible. Any workarounds or feature request much appreciated please. Thanks... > [@Displaying number](https://discuss.elastic.co/t/displaying-number/307091): > > 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] ---
**Author:** ![Marco\_Liberati](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/marco_liberati/32/82953_2.png) [@Marco\_Liberati](https://discuss.elastic.co/u/Marco_Liberati)\ **Post date:** [June 15, 2022, 8:09am UTC](https://discuss.elastic.co/t/number-in-0-0a-format-downloading-as-text-in-csv/307216/2 "2022-06-15T08:09:32Z")
Hi @behappy_alwayz0401 , each visualization should have access to the Inspector panel, which provides two option for the CSV download: `Formatted` and `Raw`. ![Screenshot 2022-06-15 at 10.08.26](https://us1.discourse-cdn.com/elastic/original/3X/5/b/5b3a622094d81e67674a40da5c322fc5fde52cc3.png) ---
**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 15, 2022, 11:27am UTC](https://discuss.elastic.co/t/number-in-0-0a-format-downloading-as-text-in-csv/307216/3 "2022-06-15T11:27:32Z")
thank you.. we are able to see the option to download formatted/raw only for chart type of visualizations which is very helpful. But for Discover reports we are unable to find such an option by clicking on "inspect". Any suggestions please..? thanks... ---
**Author:** ![Marco\_Liberati](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/marco_liberati/32/82953_2.png) [@Marco\_Liberati](https://discuss.elastic.co/u/Marco_Liberati)\ **Post date:** [June 15, 2022, 11:53am UTC](https://discuss.elastic.co/t/number-in-0-0a-format-downloading-as-text-in-csv/307216/4 "2022-06-15T11:53:36Z")
True, that only applies to visualizations. As for other sources that leverage the CSV reporting system, you can track the progress of this feature request here: [[Reporting] Exporting raw data from table-based visualizations · Issue #30982 · elastic/kibana · GitHub](https://github.com/elastic/kibana/issues/30982) ---
**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 15, 2022, 4:26pm UTC](https://discuss.elastic.co/t/number-in-0-0a-format-downloading-as-text-in-csv/307216/5 "2022-06-15T16:26:15Z")
Thank you.. ---
**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, 4:26pm UTC](https://discuss.elastic.co/t/number-in-0-0a-format-downloading-as-text-in-csv/307216/6 "2022-07-13T16:26:33Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.