Data Type | Format | Example Data | Output |
integer | zzzzzzzz | 123 | #####123 |
integer | zZzZz.Zz | 0 | ######## |
integer | zzzzzzzz.nn | 0 | ########.00 |
integer | +++,+++,+++ | 23456 | ####+23,456 |
float | ---,---,---.NN | 23456.789 | ####23,456.79 |
float | ---,---,---.zz | 3142.666 | #####-3,142.67 |
money | $$$,$$$,$$$.nnCr | 235122.21 | ###$235,122.21 |
money | $$$,$$$,$$$.nnDb | 235122.21 | ###$235,122.21Db |
money | $zz,zzz,zzn.nn | 1234.56 | $#####1,234.56 |
money | $**,***,***.nn | 12345 | $****12,345.00 |
money | +$$,$$$,$$$.nn | 54321 | ###+54,321.00 |
integer | nnn\nn\nnnn | 023243567 | 023-24-3567 |