topic Format numbers with all dots in QlikView https://community.qlik.com/t5/QlikView/Format-numbers-with-all-dots/m-p/125466#M19025 <HTML><HEAD></HEAD><BODY><P>Good morning, </P><P>I have to change the number format from this format eg 6.200.500 in 6.200,500 </P><P>I have to replace the first dot on the right in comma, how can I do?</P><P></P><P>Thanks</P></BODY></HTML> Wed, 25 Jul 2018 14:25:35 GMT Anonymous 2018-07-25T14:25:35Z Format numbers with all dots https://community.qlik.com/t5/QlikView/Format-numbers-with-all-dots/m-p/125466#M19025 <HTML><HEAD></HEAD><BODY><P>Good morning, </P><P>I have to change the number format from this format eg 6.200.500 in 6.200,500 </P><P>I have to replace the first dot on the right in comma, how can I do?</P><P></P><P>Thanks</P></BODY></HTML> Wed, 25 Jul 2018 14:25:35 GMT https://community.qlik.com/t5/QlikView/Format-numbers-with-all-dots/m-p/125466#M19025 Anonymous 2018-07-25T14:25:35Z Re: Format numbers with all dots https://community.qlik.com/t5/QlikView/Format-numbers-with-all-dots/m-p/125467#M19026 <HTML><HEAD></HEAD><BODY><P>May be try this?</P><P></P><P>= Subfield(Numb, '.', 1)&amp;'.'&amp;Subfield(Numb,'.',2)&amp;','&amp;Subfield(Numb, '.',3)</P></BODY></HTML> Wed, 25 Jul 2018 16:58:53 GMT https://community.qlik.com/t5/QlikView/Format-numbers-with-all-dots/m-p/125467#M19026 vishsaggi 2018-07-25T16:58:53Z