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

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

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)

"Shailesh Shah" wrote in message
...

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

please send the above mentioned file to my E mail id

krishnan

OK.

--
__________________________________
HTH

Bob

<Ramanathan Krishnan wrote in message
...
please send the above mentioned file to my E mail id

krishnan