What is label expression for formatting a number to have thousands separator and decimals?

[RickWarner]

I can do this in the  table, but would rather have ability in the labeling of the map.

[AnthonyGiles]

Rick,

Have a look at this article:

Make Numeric Labels More Readable

You could also use the FormatNumber function in vbscript:

http://www.esri.com/news/arcuser/1104/files/vbscript_label.pdf

Regards

Anthony

[KevinBell]

def makeMoney(n):

    import locale

    locale.setlocale(locale.LC_ALL, '')

    S = locale.currency(float(n), grouping=True)

    return S

[RickWarner]

Thank you Kevin,

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.

Richard

[KevinBell]

from the google:

http://stackoverflow.com/questions/23428660/python-locale-currency-to-0-decimals

Hopefully helpful?

[AnthonyGiles · Accepted solution]

RIck,

If you are after python specific code then you can use the str.format(), see examples here:

Python String Format Cookbook | mkaz.com

[Luke_Pinner]

A one liner (modified from code on Stack Overflow😞

"{:,}".format(int(value))