topic Re: Excel to Table formatting issues in QlikView https://community.qlik.com/t5/QlikView/Excel-to-Table-formatting-issues/m-p/589249#M218497 <HTML><HEAD></HEAD><BODY><P>By setting the format on the cells in Excel to "Text" I was able to mirror the exact formatting in the pivot table within QVW</P></BODY></HTML> Fri, 14 Feb 2014 20:00:05 GMT 2014-02-14T20:00:05Z Excel to Table formatting issues https://community.qlik.com/t5/QlikView/Excel-to-Table-formatting-issues/m-p/589248#M218496 <HTML><HEAD></HEAD><BODY><P>I currently have a pivot table that is being populated directly from an Excel spreadsheet.&nbsp; A column in the spreadsheet which I am bringing in as a field ([YTD]) has several different formatted numbers in it (i.e. percent, currency, general).&nbsp; When I bring this field into the pivot table object the formatting does not mirror Excel, some numbers are $ and others are % when they shouldn't be.&nbsp; Should every cell in Excel be set to "General"? </P><P></P><P> V11.2 SR 5 and Excel 2010</P></BODY></HTML> Fri, 14 Feb 2014 19:22:43 GMT https://community.qlik.com/t5/QlikView/Excel-to-Table-formatting-issues/m-p/589248#M218496 2014-02-14T19:22:43Z Re: Excel to Table formatting issues https://community.qlik.com/t5/QlikView/Excel-to-Table-formatting-issues/m-p/589249#M218497 <HTML><HEAD></HEAD><BODY><P>By setting the format on the cells in Excel to "Text" I was able to mirror the exact formatting in the pivot table within QVW</P></BODY></HTML> Fri, 14 Feb 2014 20:00:05 GMT https://community.qlik.com/t5/QlikView/Excel-to-Table-formatting-issues/m-p/589249#M218497 2014-02-14T20:00:05Z