This Function returns a <string>, composed by the Value formated according to the remaining parameters.
Parameters
| Value <numeric> |
| |
Number to format. |
| |
|
| Sign <numeric> |
| |
Display the sign at left of the Value.
| |
 Minus |
|
– |
|
Display only if it's a negative Value. |
| |
Always |
|
– |
|
Always display the sign. |
| |
Never |
|
– |
|
Never display the sign. |
|
| |
|
| Add Thousand Separator <boolean> |
| |
Display the Value with the thousand separator? |
| |
|
| Thousand Separator <string> |
| |
Char to represent the thousand separator. |
| |
|
| Round <boolean> |
| |
Round the value? |
| |
|
Decimal Places <numeric>
|
| |
Number of decimal places to round if the Round parameter is true.
Number of decimal places to add zeros to the right if Add Right Zeros parameter is true.
|
| |
|
| Decimal Separator <string> |
| |
Char to represent the decimal separator.
|
| |
|
Add Right Zeros <boolean>
|
| |
Use char "0" to complete the Value at right in order to achieve the number of Decimal Places to display.
|
|
|
| Example 1 |
|
Example 2 |
MaskNumber("-10000", MINUS, TRUE, ".", FALSE, 0, "", FALSE)
Result = -10.000 |
|
MaskNumber("-10000", ALWAYS, TRUE, ".", FALSE, 0, "", FALSE)
Result = -10.000 |
| |
|
|
| Example 3 |
|
Example 4 |
MaskNumber("-10000", NEVER, TRUE, ".", FALSE, 0, "", FALSE)
Result = 10.000 |
|
MaskNumber("10000", ALWAYS, TRUE, ".", FALSE, 0, "", FALSE)
Result = +10.000 |
| |
|
|
| Example 5 |
|
Example 6 |
MaskNumber("10000.5", MINUS, TRUE, ".", TRUE, 1, ",", FALSE)
Result = 10.000,6 |
|
MaskNumber("10000.55", MINUS, TRUE, ".", TRUE, 3, ",", FALSE)
Result = 10.000,55 |
|
|
|
| Example 7 |
|
Example 8 |
MaskNumber("10000.55", MINUS, TRUE, ".", TRUE, 3, ",", TRUE)
Result = 10.000,550 |
|
MaskNumber("10000.55", MINUS, TRUE, ".", FALSE, 1, ",", TRUE)
Result = 10.000,55 |
- If Round is false, Add Right Zeros is true, and the decimal places in the Value are more than Decimal Places parameter, the decimal part will remain unmodifyed (see Example 8).
|
Updated: 3/21/2018 4:25 PM |
