Custom format a number
 

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

Thank you
Meher


--
Meher
------------------------------------------------------------------------
Meher's Profile: http://www.excelforum.com/member.php...o&userid=37894
View this thread: http://www.excelforum.com/showthread...hreadid=574308

Custom format a number
 

[=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)

"Meher" wrote in
message ...

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

Thank you
Meher


--
Meher
------------------------------------------------------------------------
Meher's Profile:
http://www.excelforum.com/member.php...o&userid=37894
View this thread: http://www.excelforum.com/showthread...hreadid=574308

Custom format a number
 

Thank you Bob. You dont know how much this helps.

Meher


--
Meher
------------------------------------------------------------------------
Meher's Profile: http://www.excelforum.com/member.php...o&userid=37894
View this thread: http://www.excelforum.com/showthread...hreadid=574308