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...
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!
#\,###\,##\,##\,##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 :-))
