Format | Example Data | Report Output (^ indicates a blank space) |
'zzzzzzzz' | 123 | ^^^^123 |
'zZzZz.Zz' | 0 | ^^^^^^^^ |
'zzzzzzzz.nn' | 0 | ^^^^^^^^.00 |
'zzzzz.z^' | 123.438 | ^^123.44 |
'+++,+++,+++' | 23456 | ^^^^+23,456 |
'‑‑‑,‑‑‑,‑‑‑.NN' | 23456.789 | ^^^^^23,456.79 |
'‑‑‑,‑‑‑,‑‑‑.zz' | ‑3142.666 | ^^^^^3,142.67 |
'$$$,$$$,$$$.nnCr' | 235122.21 | ^^^$235,122.21Cr |
'$$$,$$$,$$$.nnDb' | ‑235122.21 | ^^^$235,122.21Db |
'$zz,zzz,zzn.nn' | 1234.56 | $^^^^^1,234.56 |
'$**,***,***.nn' | 12345 | $****12,345.00 |
'+$$,$$$,$$$.nn' | 54321 | ^^^+$54,321.00 |
'nnn\‑nn\‑nnnn' | 023243567 | 023‑24‑3567 |
'(zzzzz)' | ‑123 | (^^123) |