# Getting Exponential value in one of the CSV columns when downloaded from Browser

**URL:** <https://community.neo4j.com/t/getting-exponential-value-in-one-of-the-csv-columns-when-downloaded-from-browser/13108>\
**Category:** Browser\
**Created:** [December 24, 2019, 5:40am UTC](https://community.neo4j.com/t/getting-exponential-value-in-one-of-the-csv-columns-when-downloaded-from-browser/13108 "2019-12-24T05:40:08Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![akshat\_mittal](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/akshat_mittal/32/4359_2.png) [@akshat\_mittal](https://community.neo4j.com/u/akshat_mittal)\
**Post date:** [December 24, 2019, 5:40am UTC](https://community.neo4j.com/t/getting-exponential-value-in-one-of-the-csv-columns-when-downloaded-from-browser/13108/1 "2019-12-24T05:40:08Z")

</div>

Hello Team,

My concern is given below:

I am using cypher to get the output but while doing "export to CSV" from Neo4j UI , Getting Exponential value in one of the CSV columns .

 ![image](https://us1.discourse-cdn.com/flex021/uploads/neo4jcommunity/original/2X/5/55c92cb596c3d097ce7558ccb0e8f5546714756c.png)

 ![image](https://us1.discourse-cdn.com/flex021/uploads/neo4jcommunity/original/2X/f/feb255b22d5fb2de611fe37bb6dbff75c10a1e73.png)

PFA snapshot from excel and UI.

Please suggest how to handle this.

Regards  
Akshat

---

<div class="post-metadata">

**Author:** ![david\_allen](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/david_allen/32/13090_2.png) [@david\_allen](https://community.neo4j.com/u/david_allen)\
**Post date:** [December 24, 2019, 2:32pm UTC](https://community.neo4j.com/t/getting-exponential-value-in-one-of-the-csv-columns-when-downloaded-from-browser/13108/2 "2019-12-24T14:32:57Z")

</div>

This isn't cypher or Neo4j, it's excel.

Check the data type on the column in Excel and switch it to text. Note that Neo4j is exporting it as text, and so you should view it as text. Because the number is very large, Excel is switching to scientific notation to make the display of the value more compact. The value itself isn't lost, it's just that the way Excel is displaying the data is a little bit strange.

Instead of switching to text, there's also other options for manipulating how Excel displays numeric values.

---

<div class="post-metadata">

**Author:** ![akshat\_mittal](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/akshat_mittal/32/4359_2.png) [@akshat\_mittal](https://community.neo4j.com/u/akshat_mittal)\
**Post date:** [December 27, 2019, 6:06am UTC](https://community.neo4j.com/t/getting-exponential-value-in-one-of-the-csv-columns-when-downloaded-from-browser/13108/3 "2019-12-27T06:06:33Z")

</div>

Hello Allen,

Thanks a lot for making it clear.

I will check from excel end.

Regards  
AK