grouping the numbers as per indian method

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

eereokatohar - 01 Jun 2007 10:29 GMT

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

Reply to this Message

Shailesh Shah - 01 Jun 2007 11:50 GMT

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
[quoted text clipped - 4 lines]
>
> how can i do it for any digit of numbers

Reply to this Message

Bob Phillips - 01 Jun 2007 13:37 GMT

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

Signature

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
>
[quoted text clipped - 21 lines]
>>
>> how can i do it for any digit of numbers

Reply to this Message

Rate this thread: