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.





"eereokatohar" wrote:

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