Indian Style comma separator

**Bikash Shaw** · 09-25-2012, 03:46 AM

I need a Indian Style comma separator in excel with decimals

Actual Numbers
3123456110.00
3123456110.32

To be formatted as
3,12,34,56,110.00
3,12,34,56,110.32

Please help
its urgent

Thank You
Bikash Shaaw

**Ace_XL** · 09-25-2012, 04:58 AM

Try cell format

[>=1000000000]#\,##\,##\,##\,##0.00;[<=10000000]##\,##\,##0.00;##,##0.0

This will work for all numbers between 100000 and 99999999999

**Bikash Shaw** · 09-25-2012, 05:29 AM

There is a problem in it, when i type the number 45,236.00

it shows as ,45,236.00

there a extra comma in front of the digit pls help

**lesoies** · 06-02-2013, 05:04 AM

I know this is an old thread, but I also had the same issue and tried the following cell formats:

[<100000]##,##0.00;[<10000000]#\,##\,##0.00;[<1000000000]#\,##\,##\,##0.00;[<100000000000]#\,##\,##\,##\,##0.00;#\,##\,##\,##\,##\,##0.00

OR

[<100000]##,##0.00;[<10000000]#\,##\,##0.00;[<1000000000]#\,##\,##\,##0.00;#\,##\,##\,##\,##0.00

OR

[<100000]##,##0.00;[<10000000]#\,##\,##0.00;#\,##\,##\,##0.00

I created these format snippets and the last one worked for me in Office Excel 2013

You can also try a VBS:
http://www.excelfox.com/forum/f22/ex...eparation-375/