14 Replies Latest reply: Jun 13, 2013 11:30 AM by Friedrich Hofmann RSS

    How to correct cell formatting when loading from Excel?

    Friedrich Hofmann

      Hi,

       

      I have to load data (in crosstable_format) from an Excel file. Unfortunately, the data begins in row 222 with the date and in row 223 and 224 is the data. I can set the header to 221 lines and set embedded_fieldnames, no problem there, but somehow QlikView loads the data as a numeric value and the two numeric values below as dates.

      I have already checked the formatting in Excel and redone it just in case. The date is correctly formatted as date and the two values below have the formatting "General".

      I have checked the transformation wizard in QlikView, but it does not seem to offer cell reformatting.

      Can anybody help me there? Just inserting another sheet in the Excel file with formulas is a solution, but the last one I would like to choose.

      Thanks a lot!

      Best regards,

       

      DataNibbler