topic Re: What is label expression for formatting a number to have thousands separator and decimals? in Python Questions https://community.esri.com/t5/python-questions/what-is-label-expression-for-formatting-a-number/m-p/252539#M19449 <HTML><HEAD></HEAD><BODY><P>Thank you Kevin,</P><P></P><P>Is there a way to remove the decimals from the currency, but have the thousands separator. I’m dealing with Sales Price of real estate and there usually no decimal place, ie. 100,000 for a home.</P><P></P><P>Richard</P></BODY></HTML> Wed, 26 Nov 2014 17:10:13 GMT RickWarner 2014-11-26T17:10:13Z What is label expression for formatting a number to have thousands separator and decimals? https://community.esri.com/t5/python-questions/what-is-label-expression-for-formatting-a-number/m-p/252535#M19445 <HTML><HEAD></HEAD><BODY><P>I can do this in the&nbsp; table, but would rather have ability in the labeling of the map.</P></BODY></HTML> Tue, 25 Nov 2014 22:30:31 GMT https://community.esri.com/t5/python-questions/what-is-label-expression-for-formatting-a-number/m-p/252535#M19445 RickWarner 2014-11-25T22:30:31Z Re: What is label expression for formatting a number to have thousands separator and decimals? https://community.esri.com/t5/python-questions/what-is-label-expression-for-formatting-a-number/m-p/252536#M19446 <HTML><HEAD></HEAD><BODY><P>Rick,</P><P></P><P>Have a look at this article:</P><P></P><P><A href="http://www.esri.com/news/arcuser/1010/addcommatip.html" title="http://www.esri.com/news/arcuser/1010/addcommatip.html">Make Numeric Labels More Readable</A></P><P></P><P>You could also use the FormatNumber function in vbscript:</P><P></P><P><A href="http://www.esri.com/news/arcuser/1104/files/vbscript_label.pdf" title="http://www.esri.com/news/arcuser/1104/files/vbscript_label.pdf">http://www.esri.com/news/arcuser/1104/files/vbscript_label.pdf</A> </P><P></P><P>Regards</P><P></P><P>Anthony</P></BODY></HTML> Tue, 25 Nov 2014 22:38:51 GMT https://community.esri.com/t5/python-questions/what-is-label-expression-for-formatting-a-number/m-p/252536#M19446 AnthonyGiles 2014-11-25T22:38:51Z Re: What is label expression for formatting a number to have thousands separator and decimals? https://community.esri.com/t5/python-questions/what-is-label-expression-for-formatting-a-number/m-p/252537#M19447 <HTML><HEAD></HEAD><BODY><P>def makeMoney(n):</P><P>&nbsp;&nbsp;&nbsp; import locale</P><P>&nbsp;&nbsp;&nbsp; locale.setlocale(locale.LC_ALL, '')</P><P>&nbsp;&nbsp;&nbsp; S = locale.currency(float(n), grouping=True)</P><P>&nbsp;&nbsp;&nbsp; return S</P></BODY></HTML> Tue, 25 Nov 2014 22:49:31 GMT https://community.esri.com/t5/python-questions/what-is-label-expression-for-formatting-a-number/m-p/252537#M19447 KevinBell 2014-11-25T22:49:31Z Re: What is label expression for formatting a number to have thousands separator and decimals? https://community.esri.com/t5/python-questions/what-is-label-expression-for-formatting-a-number/m-p/252538#M19448 <HTML><HEAD></HEAD><BODY><P>RIck,</P><P></P><P>If you are after python specific code then you can use the str.format(), see examples here:</P><P></P><P><A href="https://mkaz.com/2012/10/10/python-string-format/" title="https://mkaz.com/2012/10/10/python-string-format/">Python String Format Cookbook | mkaz.com</A> </P></BODY></HTML> Tue, 25 Nov 2014 22:58:16 GMT https://community.esri.com/t5/python-questions/what-is-label-expression-for-formatting-a-number/m-p/252538#M19448 AnthonyGiles 2014-11-25T22:58:16Z Re: What is label expression for formatting a number to have thousands separator and decimals? https://community.esri.com/t5/python-questions/what-is-label-expression-for-formatting-a-number/m-p/252539#M19449 <HTML><HEAD></HEAD><BODY><P>Thank you Kevin,</P><P></P><P>Is there a way to remove the decimals from the currency, but have the thousands separator. I’m dealing with Sales Price of real estate and there usually no decimal place, ie. 100,000 for a home.</P><P></P><P>Richard</P></BODY></HTML> Wed, 26 Nov 2014 17:10:13 GMT https://community.esri.com/t5/python-questions/what-is-label-expression-for-formatting-a-number/m-p/252539#M19449 RickWarner 2014-11-26T17:10:13Z Re: What is label expression for formatting a number to have thousands separator and decimals? https://community.esri.com/t5/python-questions/what-is-label-expression-for-formatting-a-number/m-p/252540#M19450 <HTML><HEAD></HEAD><BODY><P>from the google:</P><P></P><P><A href="http://stackoverflow.com/questions/23428660/python-locale-currency-to-0-decimals">http://stackoverflow.com/questions/23428660/python-locale-currency-to-0-decimals</A></P><P></P><P>Hopefully helpful?</P></BODY></HTML> Wed, 26 Nov 2014 17:14:50 GMT https://community.esri.com/t5/python-questions/what-is-label-expression-for-formatting-a-number/m-p/252540#M19450 KevinBell 2014-11-26T17:14:50Z Re: What is label expression for formatting a number to have thousands separator and decimals? https://community.esri.com/t5/python-questions/what-is-label-expression-for-formatting-a-number/m-p/252541#M19451 <HTML><HEAD></HEAD><BODY><P>A one liner (modified from code on <A href="http://stackoverflow.com/questions/1823058/how-to-print-number-with-commas-as-thousands-separators">Stack Overflow</A><span class="lia-unicode-emoji" title=":disappointed_face:">😞</span></P><PRE __default_attr="python" __jive_macro_name="code" class="jive_macro_code _jivemacro_uid_14172525813859589 jive_text_macro" jivemacro_uid="_14172525813859589" modifiedtitle="true"><P><CODE><SPAN class="str">"{:,}"</SPAN><SPAN class="pun">.</SPAN><SPAN class="pln">format</SPAN><SPAN class="pun">(int(</SPAN><SPAN class="pln">value</SPAN><SPAN class="pun">))</SPAN></CODE></P></PRE></BODY></HTML> Sat, 29 Nov 2014 09:18:30 GMT https://community.esri.com/t5/python-questions/what-is-label-expression-for-formatting-a-number/m-p/252541#M19451 Luke_Pinner 2014-11-29T09:18:30Z