topic Formatting numbers in a text box in QlikView https://community.qlik.com/t5/QlikView/Formatting-numbers-in-a-text-box/m-p/265010#M1204676 <HTML><HEAD></HEAD><BODY>Try some like: =num( pi( ) , '0,00' )&amp;'%'</BODY></HTML> Mon, 12 Jul 2010 13:13:38 GMT 2010-07-12T13:13:38Z Formatting numbers in a text box https://community.qlik.com/t5/QlikView/Formatting-numbers-in-a-text-box/m-p/265009#M1204675 <HTML><HEAD></HEAD><BODY><P>Hello</P><P></P><P>I have a calculation insetrted a bit of active text in a text object .</P><P>How do I format these numbers to display as a % with two decimals as currently the result of the calculation shows as an unformatted number with decimals up to anbotu 10 places?</P><P></P><P>Jon</P><P></P><P></P><BR /><BR /></BODY></HTML> Mon, 12 Jul 2010 12:37:39 GMT https://community.qlik.com/t5/QlikView/Formatting-numbers-in-a-text-box/m-p/265009#M1204675 2010-07-12T12:37:39Z Formatting numbers in a text box https://community.qlik.com/t5/QlikView/Formatting-numbers-in-a-text-box/m-p/265010#M1204676 <HTML><HEAD></HEAD><BODY>Try some like: =num( pi( ) , '0,00' )&amp;'%'</BODY></HTML> Mon, 12 Jul 2010 13:13:38 GMT https://community.qlik.com/t5/QlikView/Formatting-numbers-in-a-text-box/m-p/265010#M1204676 2010-07-12T13:13:38Z Re: Formatting numbers in a text box https://community.qlik.com/t5/QlikView/Formatting-numbers-in-a-text-box/m-p/265011#M1204677 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 8pt;">hI</SPAN></P><P><SPAN style="color: #0000ff; font-size: 8pt;">Num</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">sum [value]</SPAN><SPAN style="font-size: 8pt;">),'# ##0.00 %') </SPAN></P><P><SPAN style="font-size: 8pt;"> NO NEED TO DEVIDE BY 100</SPAN></P><P> </P><P><SPAN style="font-size: 8pt;">THANKS</SPAN></P><P><SPAN style="font-size: 8pt;">michale</SPAN></P><P></P></BODY></HTML> Wed, 26 Mar 2014 12:40:27 GMT https://community.qlik.com/t5/QlikView/Formatting-numbers-in-a-text-box/m-p/265011#M1204677 2014-03-26T12:40:27Z Re: Formatting numbers in a text box https://community.qlik.com/t5/QlikView/Formatting-numbers-in-a-text-box/m-p/265012#M1204678 <HTML><HEAD></HEAD><BODY><P>Hi Jon,</P><P>First decide your output format using any of the chart properties number tab and copy that formatting come to text oject and paste like this,</P><P>Num(Expr1,'<STRONG>Copied Format</STRONG>')</P></BODY></HTML> Wed, 26 Mar 2014 12:48:27 GMT https://community.qlik.com/t5/QlikView/Formatting-numbers-in-a-text-box/m-p/265012#M1204678 jvishnuram 2014-03-26T12:48:27Z