Send to excel: numerical data loses its formatting
Hello
I have data in contained in an expression that I send to excel. I have changed the expression to integer in Document settings. 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.
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.
