Warning: Use of undefined constant php - assumed 'php' (this will throw an Error in a future version of PHP) in /nfs/c12/h03/mnt/220454/domains/mandarapte.com/html/wp-content/themes/mandar-apte-rwd-11-1/content-single.php on line 1

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

Leave a Reply

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