Digit Grouping

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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 said:
try this custom format

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



Kart said:
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.
Click to expand...
Click to expand...
 
Thanks a lot Venkatraman,

Aniruddha Bhide

R.VENKATARAMAN said:
try this custom format

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



Kart said:
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.
Click to expand...
Click to expand...
 
Back
Top