Instead of thousands separator, I want use hundres separator example 1,00,000

could you help me

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

"Viraj Nayaka" <Viraj wrote in message
...
Instead of thousands separator, I want use hundres separator example
1,00,000

could you help me

Hi Viraj,

Custom number format as 0","00","000 will display as per
your example. Play with other variations if you need
something slightly different.

HTH
Martin