How to format a number in Indian style in Excel?

V

Victor_alb

I am using Office 2000. My problem is that I want to display a number in
Indian style. For e.g. a number such as 158276185 is displayed as
15,82,76,185 in the Indian accounting system. The option given in Excel will
format the above number as 158,276,185. I tried a custom number format
(##","##","##","##0) which resolved the issue but created problems if the
number of digits are less. For e.g. a number such as 185 would be displayed
as ,,,185 (i.e. three commas were prefixed to the number while the same were
not required). I would be grateful if a solution is provided for the above
issue.

Thanks
Victor
 
B

Bob Phillips

Victor,

Try a format of


[>=10000000]##\,##\,##\,##0.00;[>=100000]##\,##\,##0.00;##,##0.00
 
V

Victor_alb

Bob

Thanks very much. The format worked.

Victor

Bob Phillips said:
Victor,

Try a format of


[>=10000000]##\,##\,##\,##0.00;[>=100000]##\,##\,##0.00;##,##0.00
--
HTH

-------

Bob Phillips
Victor_alb said:
I am using Office 2000. My problem is that I want to display a number in
Indian style. For e.g. a number such as 158276185 is displayed as
15,82,76,185 in the Indian accounting system. The option given in Excel will
format the above number as 158,276,185. I tried a custom number format
(##","##","##","##0) which resolved the issue but created problems if the
number of digits are less. For e.g. a number such as 185 would be displayed
as ,,,185 (i.e. three commas were prefixed to the number while the same were
not required). I would be grateful if a solution is provided for the above
issue.

Thanks
Victor
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top