topic Format number to two digit in QlikView https://community.qlik.com/t5/QlikView/Format-number-to-two-digit/m-p/524094#M195794 <HTML><HEAD></HEAD><BODY><P>How to change the format for the field data format</P><P>From 1.2.1.45. To 01.02.01.45</P><P></P><P></P><P>I want to show the two digit ,,,,</P></BODY></HTML> Sun, 30 Jun 2013 15:37:17 GMT zturaiki 2013-06-30T15:37:17Z Format number to two digit https://community.qlik.com/t5/QlikView/Format-number-to-two-digit/m-p/524094#M195794 <HTML><HEAD></HEAD><BODY><P>How to change the format for the field data format</P><P>From 1.2.1.45. To 01.02.01.45</P><P></P><P></P><P>I want to show the two digit ,,,,</P></BODY></HTML> Sun, 30 Jun 2013 15:37:17 GMT https://community.qlik.com/t5/QlikView/Format-number-to-two-digit/m-p/524094#M195794 zturaiki 2013-06-30T15:37:17Z Re: Format number to two digit https://community.qlik.com/t5/QlikView/Format-number-to-two-digit/m-p/524095#M195795 <HTML><HEAD></HEAD><BODY><P>If your string (1.2.1.45 is not a number) has always these four parts delimited by a dot, you could try like</P><P></P><P>=num(subfield('1.2.1.45','.',1),'00') &amp; '.' &amp;</P><P> num(subfield('1.2.1.45','.',2),'00') &amp; '.' &amp;</P><P> num(subfield('1.2.1.45','.',3),'00') &amp; '.' &amp;</P><P> num(subfield('1.2.1.45','.',4),'00')</P></BODY></HTML> Sun, 30 Jun 2013 15:46:26 GMT https://community.qlik.com/t5/QlikView/Format-number-to-two-digit/m-p/524095#M195795 swuehl 2013-06-30T15:46:26Z