topic Re: Need to export numbers as text in QlikView https://community.qlik.com/t5/QlikView/Need-to-export-numbers-as-text/m-p/1360990#M825071 <HTML><HEAD></HEAD><BODY><P>I have done that.&nbsp; I think the difficulty is when I export it to a csv and Excel converts the text back into a number.</P></BODY></HTML> Mon, 24 Jul 2017 18:31:26 GMT 2017-07-24T18:31:26Z Need to export numbers as text https://community.qlik.com/t5/QlikView/Need-to-export-numbers-as-text/m-p/1360988#M825069 <HTML><HEAD></HEAD><BODY><P>I have seen many posts on here in regards to export text as numbers.</P><P></P><P>My issue is the exact opposite.&nbsp; I need to export some fields that are numbers, but need them to export as text.&nbsp; (ex. 0470 needs to maintain the leading zero and be treated as four characters.)</P><P></P><P>Any help would be greatly appreciated.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Need-to-export-numbers-as-text/m-p/1360988#M825069 2020-11-25T16:16:04Z Re: Need to export numbers as text https://community.qlik.com/t5/QlikView/Need-to-export-numbers-as-text/m-p/1360989#M825070 <HTML><HEAD></HEAD><BODY><P>How are you are exporting? </P><P>Create that field as Text like </P><P></P><P>Text(NumberField) AS TextNumField</P></BODY></HTML> Mon, 24 Jul 2017 18:14:41 GMT https://community.qlik.com/t5/QlikView/Need-to-export-numbers-as-text/m-p/1360989#M825070 vishsaggi 2017-07-24T18:14:41Z Re: Need to export numbers as text https://community.qlik.com/t5/QlikView/Need-to-export-numbers-as-text/m-p/1360990#M825071 <HTML><HEAD></HEAD><BODY><P>I have done that.&nbsp; I think the difficulty is when I export it to a csv and Excel converts the text back into a number.</P></BODY></HTML> Mon, 24 Jul 2017 18:31:26 GMT https://community.qlik.com/t5/QlikView/Need-to-export-numbers-as-text/m-p/1360990#M825071 2017-07-24T18:31:26Z Re: Need to export numbers as text https://community.qlik.com/t5/QlikView/Need-to-export-numbers-as-text/m-p/1360991#M825072 <HTML><HEAD></HEAD><BODY><P>i think this thread should help!</P><P></P><P><A href="https://community.qlik.com/thread/268234">Keeping Leading Zero in Export</A></P></BODY></HTML> Mon, 24 Jul 2017 18:38:32 GMT https://community.qlik.com/t5/QlikView/Need-to-export-numbers-as-text/m-p/1360991#M825072 Frank_Hartmann 2017-07-24T18:38:32Z