Number format used in India is different from the international style. It’s same up to “Ten thousand” but after that it’s totally different. Have a quick view here below:
To know more about Indian number system please visit:
You can maintain/change the number format as you wish by changing the “Region and Language” settings of your windows operating system. The purpose of this post is to learn to change the number format to Indian style without changing it in “Region and Language” settings. You can use the below number format for correct comma separation up to “99,99,99,999.99”:[>=10000000]##\,##\,##\,##0.00;[>=100000]##\,##\,##0.00;##,##0.00
For more flexibility we may develop a macro to change the comma separation in Indian style.
In case you have any query regarding above, you may send the same as comment to this blog.
A fool’s brain digests philosophy into folly, science into superstition, and art into pedantry. Hence University education.
By Rajesh K Saraogi
Rajesh is a hardcore finance person with a penchant for latest technology. His passions is to improve the productivity with simple, yet powerful software – mainly on Microsoft Excel platform. He is a qualified MCA. Whenever he gets time he loves to blog, to share the knowledge, which is the only thing which increases after sharing!