Digit Grouping

[Guest]

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.

 

[R.VENKATARAMAN]

try this custom format

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

 

[Guest]

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

try this custom format

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

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.

 

[Guest]

Thanks a lot Venkatraman,

Aniruddha Bhide

try this custom format

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

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.