custom format

[TUNGANA KURMA RAJU]

I want format a number comma separate in thousands,lacs,crores.I didn't fond
custom format for this eg. 100500700 to 10,05,00,700.
and also like to format the same 10.05 crores.

 

[Toppers]

Previous posting from Bob Phillips:

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

will format say 1234567890 as 123,45,67,890.00

HTH