https://community.qlik.com/t5/QlikView/alphanumeric-formatting-in-QlikView/m-p/1893164#M1217385 <P>Hi All,</P> <P>&nbsp;I have a column from an excel source which looks like below.</P> <TABLE width="187"> <TBODY> <TR> <TD width="147">Col1</TD> <TD width="40">Col2</TD> </TR> <TR> <TD>8.70773E+11</TD> <TD>Deesc1</TD> </TR> <TR> <TD>01598705SKY2SUW</TD> <TD>Desc2</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>And I want the output to look like below.&nbsp; I tried using Num and Text functions in load script, but it does not seem to work. How to fix this issue?</P> <TABLE width="187"> <TBODY> <TR> <TD width="147">Col1</TD> <TD width="40">Col2</TD> </TR> <TR> <TD>87077286047333</TD> <TD>Deesc1</TD> </TR> <TR> <TD>01598705SKY2SUW</TD> <TD>Desc2</TD> </TR> </TBODY> </TABLE> Tue, 15 Feb 2022 14:22:20 GMT Krish 2022-02-15T14:22:20Z https://community.qlik.com/t5/QlikView/alphanumeric-formatting-in-QlikView/m-p/1893164#M1217385 <P>Hi All,</P> <P>&nbsp;I have a column from an excel source which looks like below.</P> <TABLE width="187"> <TBODY> <TR> <TD width="147">Col1</TD> <TD width="40">Col2</TD> </TR> <TR> <TD>8.70773E+11</TD> <TD>Deesc1</TD> </TR> <TR> <TD>01598705SKY2SUW</TD> <TD>Desc2</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>And I want the output to look like below.&nbsp; I tried using Num and Text functions in load script, but it does not seem to work. How to fix this issue?</P> <TABLE width="187"> <TBODY> <TR> <TD width="147">Col1</TD> <TD width="40">Col2</TD> </TR> <TR> <TD>87077286047333</TD> <TD>Deesc1</TD> </TR> <TR> <TD>01598705SKY2SUW</TD> <TD>Desc2</TD> </TR> </TBODY> </TABLE> Tue, 15 Feb 2022 14:22:20 GMT https://community.qlik.com/t5/QlikView/alphanumeric-formatting-in-QlikView/m-p/1893164#M1217385 Krish 2022-02-15T14:22:20Z