5 Replies Latest reply: May 3, 2016 5:03 AM by Madeleine Josefsson RSS

    Zeroes goes missing when exporting to Excel

    Madeleine Josefsson

      Hi,

      I have a column in a table where some values start with some zeroes, for example 00053300. When I export this table to excel the first two zeroes goes missing.

       

      I have written 'text' in front of the field (CustomerOrderNumber) in the transform stage, and also in the data load editor and in the field for the table.

      For example:

       

      How can I make a change so that the export is with zeroes?

      From QlikSense:

      From Excel:

       

      Thanks!