5 Replies Latest reply: Dec 4, 2014 4:10 AM by Sriharsha Pillarisetty RSS

    Exporting large tables to excel with numbers as text

    Joey Stekkinger

      Dear community,

      On a regular basis, I have to export large table to excel. One of the columns consists of EAN's, which are displayed as 13 numbers, but should have the format of text to make sure that EAN's starting with 0 do not loose their structure.

       

      When I export these tables it goes well unless it has more than a certain amount of rows. Then my exports look like these:

      EAN.png

       

       

      I tried exporting as CSV, but it shows the same result.

      Does anyone know how to make sure this column is exported as a text-column?