topic Send to excel: numerical data loses its formatting in QlikView https://community.qlik.com/t5/QlikView/Send-to-excel-numerical-data-loses-its-formatting/m-p/1095563#M363976 <HTML><HEAD></HEAD><BODY><P>Hello</P><P>I have data in contained in an expression that I send to excel.&nbsp; I have changed the expression to integer in Document settings.&nbsp; Numbers are being sent to excel as numbers. However where there is no data, it shows as a dash in QlikView "-" which is fine but when this data is in excel, the format is 'General' and therefore you cannot do formulas on it eg Cell A plus Cell B - you get #Value! errors.</P><P></P><P>Do you know how you can get around this and have all the data come over as Number format even where there is no data.</P><P></P><P>Hope that makes sense</P><P></P><P>Paul</P></BODY></HTML> Thu, 28 Jan 2016 17:36:30 GMT paul_ripley 2016-01-28T17:36:30Z Send to excel: numerical data loses its formatting https://community.qlik.com/t5/QlikView/Send-to-excel-numerical-data-loses-its-formatting/m-p/1095563#M363976 <HTML><HEAD></HEAD><BODY><P>Hello</P><P>I have data in contained in an expression that I send to excel.&nbsp; I have changed the expression to integer in Document settings.&nbsp; Numbers are being sent to excel as numbers. However where there is no data, it shows as a dash in QlikView "-" which is fine but when this data is in excel, the format is 'General' and therefore you cannot do formulas on it eg Cell A plus Cell B - you get #Value! errors.</P><P></P><P>Do you know how you can get around this and have all the data come over as Number format even where there is no data.</P><P></P><P>Hope that makes sense</P><P></P><P>Paul</P></BODY></HTML> Thu, 28 Jan 2016 17:36:30 GMT https://community.qlik.com/t5/QlikView/Send-to-excel-numerical-data-loses-its-formatting/m-p/1095563#M363976 paul_ripley 2016-01-28T17:36:30Z