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
- 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 :)) - 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😊
