# Format issue with generate csv

**URL:** <https://community.glideapps.com/t/format-issue-with-generate-csv/73782>\
**Category:** Ask for Help\
**Tags:** actions\
**Created:** [May 31, 2024, 5:27pm UTC](https://community.glideapps.com/t/format-issue-with-generate-csv/73782 "2024-05-31T17:27:26Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![zephir](https://avatars.discourse-cdn.com/v4/letter/z/e95f7d/32.png) [@zephir](https://community.glideapps.com/u/zephir)\
**Post date:** [May 31, 2024, 5:27pm UTC](https://community.glideapps.com/t/format-issue-with-generate-csv/73782/1 "2024-05-31T17:27:26Z")

</div>

Hi,

I use generate csv to generate an export with 2 fields.  
The problem is one field needs to be reformatted in excel sheet.  
The EAN field has an exponential format. After each export, it must be manually transformed into a integer numeric format.  
How can I avoid this and obtain a valid format without manual updates.

 ![glide](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/2/822c6a790ecb788af4b2b4d244fddbb027aac4c9.jpeg)  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/c/7cc7d0e70e0960a2507d32884912d88148dba434.png)

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [May 31, 2024, 11:12pm UTC](https://community.glideapps.com/t/format-issue-with-generate-csv/73782/2 "2024-05-31T23:12:14Z")

</div>

You could probably trick it into being a text value instead of a numeric value by appending some sort of non numeric character at the beginning or end of the number. Other than that, it’s more of an Excel issue.

---

<div class="post-metadata">

**Author:** ![zephir](https://avatars.discourse-cdn.com/v4/letter/z/e95f7d/32.png) [@zephir](https://community.glideapps.com/u/zephir)\
**Post date:** [June 1, 2024, 9:56am UTC](https://community.glideapps.com/t/format-issue-with-generate-csv/73782/3 "2024-06-01T09:56:05Z")

</div>

Thanks for your answer.

I have tested by replacing numeric by text field in glide table, but the problem persists.

Adding a non numeric character is not a solution for my case because it will disturb the next step import in an external application.