grouping the numbers as per indian method
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 |
grouping the numbers as per indian method
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 |
grouping the numbers as per indian method
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 |
Download indian rupees .xla fie
please send the above mentioned file to my E mail id
krishnan |
Download indian rupees .xla fie
OK.
-- __________________________________ HTH Bob <Ramanathan Krishnan wrote in message ... please send the above mentioned file to my E mail id krishnan |
All times are GMT +1. The time now is 02:44 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com