Hi there,
Anyone knows how group the digits the Indian way? Ex: 12,34,56,000 instead
of the usual way of 123,456,000. Last three digits one group, after that a
group consists of 2 digits each.

try this custom format

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



"Kart" wrote in message
...
Hi there,
Anyone knows how group the digits the Indian way? Ex: 12,34,56,000 instead
of the usual way of 123,456,000. Last three digits one group, after that a
group consists of 2 digits each.

Hi Venkatraman,

Thanks, it works for upto lakhs, but not crores. I have figured out to put
additional formatting for crores, but there is an extra comma for lakhs if
formatting for crores. Cant we make excel use what the system uses?

Kart

"R.VENKATARAMAN" wrote:

try this custom format

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



"Kart" wrote in message
...
Hi there,
Anyone knows how group the digits the Indian way? Ex: 12,34,56,000 instead
of the usual way of 123,456,000. Last three digits one group, after that a
group consists of 2 digits each.

Thanks a lot Venkatraman,

Aniruddha Bhide

"R.VENKATARAMAN" wrote:

try this custom format

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



"Kart" wrote in message
...
Hi there,
Anyone knows how group the digits the Indian way? Ex: 12,34,56,000 instead
of the usual way of 123,456,000. Last three digits one group, after that a
group consists of 2 digits each.