Currency can be formatted in a locale-sensitive manner.
You can choose one of several predefined currency formats, or type in a custom format string:
Value |
Format Pattern |
Locale |
Formatted Currency |
3456.78 |
$#,##0.00 (Default) |
US |
$3,456.78 |
123456.789 |
$##,###.## |
US |
$123,456.79 |
123456.789 |
$##,###.## |
China |
¥123,456.79 |
Symbol |
Description |
. (period) |
Decimal separator |
, (comma) |
Thousand separator |
0 |
Digit placeholder, display a digit or 0 |
# |
Digit placeholder, display a digit or nothing |