Thread: Digit Grouping
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
R.VENKATARAMAN
 
Posts: n/a
Default Digit Grouping

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.