1 Reply Latest reply: Aug 24, 2017 8:50 PM by An Pham RSS

    Excel load text converted to number

    Craig Calvert

      Hello,

       

      Am trying to load a spreadsheet into Qlik Cloud that will act as a dimension (see attaced).

       

      I have a number of values in a column that is a text column but they are all look like numbers.....

       

      000

      0000

      1000

      100

      2000

      200

      etc, etc

       

      After the upload, 0000 is no longer in the table and it looks like it has merged this with 000.

       

      It looks like its converted to a number....but how do I force the upload to treat this as a text so I have two separate values?