topic Re: Number conversion in QlikView https://community.qlik.com/t5/QlikView/Number-conversion/m-p/1012690#M928301 <HTML><HEAD></HEAD><BODY><P>or else u can change the&nbsp; format in&nbsp; Number tab&nbsp;&nbsp; </P></BODY></HTML> Wed, 30 Mar 2016 08:57:26 GMT Chanty4u 2016-03-30T08:57:26Z Number conversion https://community.qlik.com/t5/QlikView/Number-conversion/m-p/1012687#M928294 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>We have used excel as an data source in that Device id is an dimension.</P><P>When we imported the data in qlikview the device id is came out as below.</P><P></P><P><IMG alt="Untitled.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/119810_Untitled.png" style="height: auto;" /></P><P></P><P>How convert the same into numeric in qlikview.</P><P></P><P>Thanks..</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Number-conversion/m-p/1012687#M928294 nareshthavidishetty 2020-11-25T16:16:04Z Re: Number conversion https://community.qlik.com/t5/QlikView/Number-conversion/m-p/1012688#M928296 <HTML><HEAD></HEAD><BODY><P>May be like this:</P><P></P><P><STRONG>Num([Device ID], '##.####') as [Device ID]</STRONG></P></BODY></HTML> Wed, 30 Mar 2016 08:48:00 GMT https://community.qlik.com/t5/QlikView/Number-conversion/m-p/1012688#M928296 sunny_talwar 2016-03-30T08:48:00Z Re: Number conversion https://community.qlik.com/t5/QlikView/Number-conversion/m-p/1012689#M928299 <HTML><HEAD></HEAD><BODY><P><STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Num([Device ID)/10000, '##.00')</STRONG></P></BODY></HTML> Wed, 30 Mar 2016 08:51:06 GMT https://community.qlik.com/t5/QlikView/Number-conversion/m-p/1012689#M928299 Chanty4u 2016-03-30T08:51:06Z Re: Number conversion https://community.qlik.com/t5/QlikView/Number-conversion/m-p/1012690#M928301 <HTML><HEAD></HEAD><BODY><P>or else u can change the&nbsp; format in&nbsp; Number tab&nbsp;&nbsp; </P></BODY></HTML> Wed, 30 Mar 2016 08:57:26 GMT https://community.qlik.com/t5/QlikView/Number-conversion/m-p/1012690#M928301 Chanty4u 2016-03-30T08:57:26Z