Formatting a numeric field- round to 10s or 100s

Question

When formatting a numeric field in a table, rounding to decimal places or significant numbers is straightforward- but how do I round to the nearest 10 or 100 (ie to the left of the decimal)? My numbers range from 41 the over 1,000,000 and I'd like them all to display as x,xyz,xx0. I've played around with all the numeric options and custom formatting, but can't find a way- is it possible?

DanPatterson_Retired · Answer

It requires a new field, there is no way to display rounding in the table beyond rounding to 0 decimal places.

Scientific notation won't help much, it would look just as ugly in the report table

AaronWorthley1 · Answer

Right, but I'm not trying to calculate a new or existing field, rather just formatting an existing field using the numeric formatting dialog. In a python expression, you use a negative number to round left of the decimal, but the numeric field formatting dialog won't accept negative numbers in the rounding>decimal places entry.

I'm hoping to format an auto-calculated geodatabase area field for use in a layout table frame. I don't want to have to recalculate the field (and rebuild the table frame) every time the underlying geometry changes.

JoeBorgione · Answer

The round() function in python can do it for you: numList = [41, 63, 47, 116, 1000055] for n in numList: print(round(n,-1)) #returns: 40 60 50 120 1000060‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ In a field calculator it looks like: