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