A format mask indicates how to format the target currency value. A format mask is composed of the following characters:
A format mask is used to format the value matched by the validation mask into a specific numeric pattern. The format examples in Table 315 have the following defaults:
SYSDECCHAR=DOT
%%ROUND_CURRENCY=YES
Table 315 Formatting values using a format mask
Value to Format |
Format Mask |
||||||||
---|---|---|---|---|---|---|---|---|---|
|
###.## |
ZZZ.ZZ |
Z,ZZZ.## |
-###.## |
+ZZZ.## |
###.##- |
ZZZ.ZZ- |
###.##+ |
+ZZZ.## |
102.319 |
102.32 |
102.32 |
102.32 |
102.32 |
+102.32 |
102.32 |
102.32 |
102.32+ |
+102.32 |
20.0 |
020.00 |
20.00 |
20.00 |
020.00 |
+20.00 |
020.00 |
20.00 |
020.00+ |
+20.00 |
20.03 |
020.03 |
20.03 |
20.03 |
020.03 |
+20.03 |
020.03 |
20.03 |
020.03+ |
+20.03 |
.03 |
000.03 |
.03 |
.03 |
000.03 |
+.03 |
000.03 |
.03 |
000.03+ |
+.03 |
3.9+ |
003.90 |
3.90 |
3.90 |
003.90 |
+3.90 |
003.90 |
3.90 |
003.90+ |
+3.90 |
3.9- |
-03.90 |
-3.90 |
-3.90 |
-003.90 |
-3.90 |
003.90- |
3.90- |
003.90- |
-3.90 |
3.0- |
-03.00 |
-3.00 |
-3.00 |
-003.00 |
-3.00 |
003.00- |
3.00- |
003.00- |
-3.00 |
.484 |
000.48 |
.48 |
.48 |
000.48 |
+.48 |
000.48 |
.48 |
000.48+ |
+.48 |
. |
000.00 |
.00 |
.00 |
000.00 |
+.00 |
000.00 |
.00 |
000.00+ |
+.00 |
9999.999 |
****** |
****** |
9,999.99 |
******* |
******* |
******* |
******* |
******* |
******* |
-999.999 |
****** |
****** |
******** |
******* |
******* |
******* |
******* |
******* |
******* |
Note: If the value of SYSDECCHAR is COMMA, the decimal point indicator is a comma and the thousands separator is a period.
If overflow of significant digits occurs during formatting, the formatted value will consist entirely of asterisks.
If one or more blanks occur between a plus or minus sign on the left and a number on the right, the sign is shifted to the right until it is adjacent to the number.
Parent Topic |