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...
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
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 :)) - You can also use \ as an escape character. Hence
#\,###\,##\,##\,##0.00
should also work. On the other hand
0 "dog biscuits";;"Out of dog biscuits"
is better with double-quotes!- It worked! Thank you so much😊
- Once again it has been proven that there are many ways to find a solution in excel.
Rome had fewer routes available :)))
Let's enjoy Excel, with a cup of chocolate and two biscuits everyone :-))
It's a nice trick, but such formats have the disadvantage that they don't work well for all numbers:
 
Good point!
[<100000]#,##0.00;[<10000000]#\,##\,##0.00;###\,##\,##0.00
will deal with smaller numbers but then the number formats would need to be combined with conditional formatting to accommodate very large numbers.
