Product: LABEL MATRIX
Version: All Versions
|
|
FormatNumber(number): This function allows you to format a numeric field where a pound sign (#) means only display if a value is there and zero (0) means always display.
|
Expression |
Result |
|
FormatNumber(123.45, "US$ #,###,###.00") |
US$ 123.45 |
|
FormatNumber(123.45, "US$ 0,000,000.00") |
US$ 0,000,123.45 |
|
FormatNumber(.45, "#,##0.00") |
0.45 |
|
FormatNumber(.45, "#,###.00") |
45 |
|
FormatNumber(7188302335, "(###) ###-####") |
(718) 830-2335 |
|
FormatNumber(123.45, "00.00") |
23.45 |
|
FormatNumber(123.567, "###,##0.00") |
123.57 |
|
|