Formatting numbers in Indian style

[paramnayak]

how can i format numbers in the range 0 to 10 crores in indian style eg representing 1 lakh as 1,00,000.00 or 1 cr as 1,00,00,000.00.


Custom format can take only 2 conditions eg [>99999]##,##,##0.00;[>999] ##,##0.00 ;##0.00 works fine

If i add one more condition like [>9999999] it will not work

 

[GeorgeF211]

To clarify, are you looking for something that would say

1 crores, 11 lakh, 3 Sau 1 ek, or 1.1100301 crore? (Also am I understanding the number system here right - not one I'm familiar with?)

 

[bobhc]

Good day paramnayak


Will this link help


http://chandoo.org/wp/2010/07/26/indian-currency-format-excel/

 

[GeorgeF211]

wow, that's much more sensible than the way I was looking to go about it.