6 Replies Latest reply: Nov 26, 2015 10:46 PM by Prashant Sangle RSS

    Loading scientific values from CSV

    DANIEL CHOTZEN

      Hi,

      i have a csv with values in scientific notation, for example:   5.15062E+12

      qhwn i open this CSV in EXCEL and change the cell format to Number i get this value: 5150615600780

       

      which is the correct value

       

       

      but when i load the CSV file into qlikview it loads in the E+ format 5.15062E+12

      and when i change it to number in the object properties NUMBERS tab

      it shows this:5150620000000

       

      how can i load it so it shows the correct value like in excel: 5150615600780

       

      thanks

      Daniel