Forum Discussion
Question related to Number format
Hello Everyone, I would to add the below comma separation format in the numeric value. Presently I have 1,000,000,000.00 But I would like to add 100,00,00,000.00 in this format...??? OR Wh...
If you want to use the Indian Numbering System, you must select the corresponding digit grouping setting 12,34,56,789 in the Currency and Number tabs of Customize Format (press Windows key+R, type control intl.cpl and press Enter or click OK, then click Additional settings...)
1000000000 will then be displayed as 1,00,00,00,000.00
As far as I know, there is no way to make Excel format it as 100,00,00,000.00