Custom format a number

M

Meher

I need help how to custom format a number. When I type in 18000000.0
it shows by default as 18,000,000.00. I need it to show a
1,80,00,000.00. Can this be done in custom format.

Thank you
Mehe
 
B

Bob Phillips

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

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

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Top