Solved Exporting to csv file loses number format

[Number11]

I am trying to export a table to a csv file but the numbers are showing up like this

Guess i need to have some formatting added to a query?

 

[arnelgp]

the values are too "small" as you can see.

 

[Number11]

the values are too "small" as you can see.

dont understand as then if i open the file in excel and change the format its all correct?

 

[AngelSpeaks]

Nothing to worry about. The Excel column is too small to display. Expand the column to see the full number.

 

[Pat Hartman]

Once you open Excel, be sure to change the format of those columns to text. NOT general. TEXT. Unless you need to do arithmetic. In which case, use a specific numeric format. Otherwise, you could end up with the long numbers saved in scientific notation and loose part of the values.