Format issue with generate csv


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.

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.

1 Like

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.