Take the 2-minute tour ×
Ask Different is a question and answer site for power users of Apple hardware and software. It's 100% free, no registration required.

Indian rupee number format is different from US number format. e.g. 1,00,00,00,000 http://en.wikipedia.org/wiki/Indian_rupee

How do I setup a custom number format in Numbers?

share|improve this question

1 Answer 1

up vote 2 down vote accepted

You didn't mention which version of Numbers you were using. Here are general directions to create a custom cell format in both Numbers '08 (1.0) and Numbers '09 (2.0).

In Numbers '09, once in the Custom Number Format dialog, drag a few integer elements into the format box. Pull the menu down for each, and choose Hide separator. On the appropriate groups, change the number of digits to two.

Screenshot of Custom Number Format dialog

If you're not mixing with USD and prefer India's conventions, a much simpler approach is in the Language & Text panel of System Preferences. Choose India from the Region menu, and any cells set to Currency format will not only have the correct symbol, but the correct groupings. Of course, then if you want USD formatted correctly, you'd need a custom format for that - so use whichever region is most appropriate to the bulk of your content.

share|improve this answer
    
Great, is there a way to not suppress unwanted commas for smaller number. e.g. I am seeing ,,,15,000 for 15,000 –  Iam Mar 10 '12 at 23:43

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.