grouping the numbers as per indian method

[eereokatohar]

sir,
i wnt to group number as follow

for, 1234567891213456.75

as 1,23,45,67,891,2,13,456.75 (i.e. indian method of grouping pg numbers)

how can i do it for any digit of numbers

 

[Shailesh Shah]

You can use below format for only positive no. upto 99,99,99,999.99


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

You may download my addins "Indain Rupees.xla" from below site. With this
you can format No as Indian Number System & also convert No. in to words as
per Indian Lac format.


Regards,

Shailesh Shah
http://in.geocities.com/shahshaileshs/
(Excel Add-ins Page)
If You Can't Excel with Talent, Triumph with Effort.

 

[Bob Phillips]

Note that this doesn't work for negative numbers, and (AFAIK) cannot be
extended to negative numbers as it runs out of options.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

You can use below format for only positive no. upto 99,99,99,999.99


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

You may download my addins "Indain Rupees.xla" from below site. With this
you can format No as Indian Number System & also convert No. in to words
as
per Indian Lac format.


Regards,

Shailesh Shah
http://in.geocities.com/shahshaileshs/
(Excel Add-ins Page)
If You Can't Excel with Talent, Triumph with Effort.

sir,
i wnt to group number as follow

for, 1234567891213456.75

as 1,23,45,67,891,2,13,456.75 (i.e. indian method of grouping pg
numbers)

how can i do it for any digit of numbers

 

[Ramanathan Krishnan]

please send the above mentioned file to my E mail id

krishnan

 

[Bob Phillips]

OK.