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'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.