How to format a number in Indian style in Excel?
 

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

Victor,

Try a format of


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

-------

Bob Phillips
"Victor_alb" wrote in message
...
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

Bob

Thanks very much. The format worked.

Victor

"Bob Phillips" wrote:

Victor,

Try a format of


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

-------

Bob Phillips
"Victor_alb" wrote in message
...
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