Summary
Are {0:#,##}
and {0:#,#}
different? I know that the .
determines the location of the decimal separator in the result string, and the ,
serves as both a group separator and a number scaling specifier. As a group separator, it inserts a localized group separator character between each group. As a number scaling specifier, it divides a number by 1000 for each comma specified.
Example
Take a look at some examples:
original #,## #,#
12568 -> 12,568 12,568
12568.12 -> 12,568 12,568
1.12 -> 1 1
.12 -> Error Error
They are all the same even in error.
Question
Why the decimal part does not appear in the examples? How to add decimal separator to a grouped (money like) number?