Indian System

[Rajesh]

I enquired about the Indian system ( Numbers to be
displayed as 12,34,56,789.00 instead of 123, 456, 789.00)
earlier.

SOme of our friends were kind enough to send reply.

Those alterations or the changes are applicable to one
sheet oonly. When a new sheet is opened, I cannot see the
custom value in the format Options.

Can Any one help me in changing this digit grouping to
Indian style.

Thanks

 

[David McRitchie]

Hi Rajesh,
You have to apply the formatting to cell you want it to apply to.

It sounds like you have the information but are asking for it again.
The following if for positive numbers only.

[>=10000000]##\,##\,##\,##0.00;[>=100000]##\,##\,##0.00;##,##0.00

(This format separates groups for India/Thailand, format valid for positive numbers up to 99,99,99,999.99 or 999,999,999.99) in
Excel XP see function BhatText as in Thai Bhat currency. =BAHTTEXT(A37) [Rupees, Rs., Paise, lakhs, crores] == an alternative may
be to use Control Panel, Regional Settings, Numbers, digit grouping.
Negative and Positive Numbers can be handled with a subroutine or event macro.

There are some hyperlinks in the above you can get to them from
Show FORMULA or FORMAT of another cell
http://www.mvps.org/dmcritchie/excel/formula.htm#cellformat