...
Number - Used to format numbers. There are additional options to format Options here can use Thousands(1000) Separator and show zero balance of the field. And, also allows zero or blank fill for the field.
In the example below you can see the differences between all options. The length of data is 10 and 2 decimals.
- For 1000 Separator the source data '1200000.00' would appear as '1,200,000.00' in the output.
- Show Zero Balance has source data '00' would appear as '.00' in the output.
- For Blank fill the source data '12.34 ' would appear as '12.34' in the output.
- For Zero fill the source data '12345.60' would appear as '00012345.60' in the output.
- Edit Word - Used to format a numeric field with an editing pattern you specify.
...