topic EXPORT XLS FORMATTED AS TEXT IN QLIKVIEW RATHER THAN NUMBER in QlikView https://community.qlik.com/t5/QlikView/EXPORT-XLS-FORMATTED-AS-TEXT-IN-QLIKVIEW-RATHER-THAN-NUMBER/m-p/1074601#M944342 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>With my current requirement, I am asking Qlikview to show all product values and populate missing values with a '0'. However when I export to excel, the populated 0 values are formatted as text when I need them to be formatted as a number! The object I am exporting is a pivot table. Is there any work around for this? Thanks!</P><P></P><P>Things I have tried.</P><UL><LI>num function around the expression</LI><LI>using the number tab</LI><LI>trying to trick excel by right aligning any text on the presentation tab</LI></UL><P></P><P>My feeling is Qlikview is programmed to populate missing cells with only text values rather than numeric.</P></BODY></HTML> Fri, 20 Nov 2020 18:02:30 GMT jcramirez472 2020-11-20T18:02:30Z EXPORT XLS FORMATTED AS TEXT IN QLIKVIEW RATHER THAN NUMBER https://community.qlik.com/t5/QlikView/EXPORT-XLS-FORMATTED-AS-TEXT-IN-QLIKVIEW-RATHER-THAN-NUMBER/m-p/1074601#M944342 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>With my current requirement, I am asking Qlikview to show all product values and populate missing values with a '0'. However when I export to excel, the populated 0 values are formatted as text when I need them to be formatted as a number! The object I am exporting is a pivot table. Is there any work around for this? Thanks!</P><P></P><P>Things I have tried.</P><UL><LI>num function around the expression</LI><LI>using the number tab</LI><LI>trying to trick excel by right aligning any text on the presentation tab</LI></UL><P></P><P>My feeling is Qlikview is programmed to populate missing cells with only text values rather than numeric.</P></BODY></HTML> Fri, 20 Nov 2020 18:02:30 GMT https://community.qlik.com/t5/QlikView/EXPORT-XLS-FORMATTED-AS-TEXT-IN-QLIKVIEW-RATHER-THAN-NUMBER/m-p/1074601#M944342 jcramirez472 2020-11-20T18:02:30Z