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
What should i write in Format Cells -
Please help...??
11 Replies
Cell formatting
Custom
Type: insert -> ### "." ## "," ## "," ### "." ##Format Cell:
###"."##","##","###"."##
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here
- it worked! Thank you so much😊
- great tip , "," never knew that in excel number formatting, where did you learn it? 🙂
- I'm getting old and I'm still learning a lot (Solon)
... because I know that I don't know anything. Socrates)
It is always nice to learn something new, love the ignorant for their happiness. Nikolino
...old German school
Thanks for the good words :))
- i dont think its possible as , is thousand seperator
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
