When creating a new field with a type of Numeric Format, you need to select the format type from the Format drop-down.
Depending on the Length you have entered for this field, different Format values are available. A Length of 8 or greater will allow you to view and select from all the available formats.
The following table describes each format type
| Format Character | Description | Example | Example of Input | Example of Output |
|---|---|---|---|---|
| (Blank - no characters) |
The blank format is the first option in the Format drop-down field. It is displayed as a blank format with no numbers, letters or other characters. The data is captured as is; no validation is performed.
|
(Not applicable) |
Any combination of characters can be entered, for example: $567,234.23 CR |
Output will be identical to the input, for example: $567,234.23 CR |
| 9 |
A nine (9) accepts any number (0-9) in the specified position of the field. Leading zeroes will be inserted as needed. |
999999 |
123 |
000123 |
|
, (comma) |
A comma (,) will be automatically inserted in the specified positions of the field. |
9,999.99 9,999.99 9,999.99 |
1234.56 1.23456 12345 |
1,234.56 0,001.23 Not accepted - invalid entry because decimal is missing in input |
| Z | A Z automatically suppresses leading zeros in the specified positions of the field. |
ZZ,ZZZ.ZZ Z,ZZZ.99 |
1234.5 12 |
1,234.5 12.00 |
| $ |
A $ automatically inserts a dollar sign in the specified position of the field.
|
$9,999.99 $Z,ZZZ.99 $ZZZ |
1.23 1.23 123 |
$0,001.23 $1.23 $123 |
| $$ |
$$ automatically inserts dollar signs in the specified positions of the field. Each leading zero is replaced with a $. |
$$999.99 $$ZZZ.99 $$999.99 |
1.23 123 123 |
$$$$1.23 $$123.00 $$123.00 |
|
- (minus sign) |
A minus sign (-) is inserted at the start or end of the field. |
-ZZZ9.99 ZZZ9.99- |
123.56 123.56 |
-123.56 123.56- |
|
+ (minus sign) |
A plus sign (+) is inserted at the start or end of the field. |
+ZZZ9.99 ZZZ9.99+ |
123.56 123.56 |
+123.56 123.56+ |
|
% (percent sign) |
A perecent sign (%) is inserted at the end of the field. |
-ZZ9.99% +ZZ9.99% |
12.34 123.45 |
-12.34% +123.45% |
|
* (asterix) |
An asterix automatically inserts leading asterixes.Each leading zero is replaced with an asterix.
|
$*99,999 $*ZZ,ZZZ |
1234 1234 |
$*01,234 $**1,234 |
| CR, DB, DR | Insert CR (credit), DB (debit) or DR (debit) at the end of the field |
$ZZZ9.99CR ZZ9.99DR |
123.45 12.34 |
$123.45CR 12.34DR |
© Copyright 2010, Oracle and/or its affiliates. All rights reserved. Legal notices.