Previous posting from Bob Phillips:

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

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

HTH


"TUNGANA KURMA RAJU" wrote:

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.