grouping the numbers as per indian method

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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 said:
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 said:
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
Click to expand...
Click to expand...
 
Back
Top