How to add / insert comma to numerical values for more than three digits in Apple (iWork) Numbers for every thousands separator on Macintosh (OSX)

While working in Apple Numbers calculating your expenses, expenditures & revenue you may think whether it can be more helpful to have separator after every thousands, millions & billions for American, UK, Europe based calculations in Dollars ($) & Pounds (£) or euro (€) or in Indian rupees (₹) for every thousand, lac & crore.

 
In simple words your & mine common problem is unreadable & unrecognisable number like: 1000000

 
So you want it display for USD something Like this: 1,000,000

 
OR for Indian subcontinent you may want it to display numbers in 10,00,000 with logical separators

 
Here is the solution:

 

First Thing first: If you are from India & you want to see numerical values as thousand, lacs & crore then change your ‘Language & Region’ settings in your ‘System Preferences’ to something like this

 
Language-Region-OSX

 
Path: Navigate to Applications folder > System Preferences > Language & Region

 
Now change settings as per following: Region: India & other settings as per image if required.

 
Now follow below steps:

 

Now this step is common for every user from every part of the world from US, UK, Europe, India or Australia.

 
Step 01: open Numbers if it is not open create new document or open existing one where you want to see thousand separators.

 
Step 02: Now select your respective table & it’s respective numerical field in particular column

 
Step 03: Now in right sidebar / Inspector under ‘Cell’ tab choose currency as Data Format & check Thousand Separator checkbox

 
Apple-Numbers-Inspector-Thousands-Seperator

 
Step 04: You are done

 
Hope it helps.

 
Thanks & Regards
Mandar Apte

Mandar Apte

This website contains a design articles blog by Mandar Apte. He writes and shares his iOS development, graphic, web, & animation film design experience through articles. Mandar is Mumbai based multi-disciplinary designer with expertise in UI, UX, Logo, Symbol, and Brand Identity design. He is an alumnus of Sir J. J. Institute of Applied Art, Mumbai. He currently runs his studio in the heart of the city of Mumbai.

Leave a Reply

Your email address will not be published. Required fields are marked *