Allows a user defined format for a column. The format is made up of the the following symbols:
| Character | Description |
|---|---|
| # |
Placeholder that displays the digit from the value if it is present. If fewer placeholder characters are used than in the passed number, then the result is rounded. |
| 0 |
Placeholder that displays the digit from the value if it is present. If no digit is present, 0 (zero) is displayed in its place. |
| . |
Placeholder for the position of the decimal point. You must always use a . in the format string, OxonStat will use the correct format for your country. |
| , |
Placeholder that indicates that the number should be formatted with thousands separators. You must always use a , in the format string, OxonStat will use the correct thousand symbol for your country. |
| % | Displays the number multiplied by 100 followed by the % character. |
| E or e | Displays the number in scientific notation. |
| \character | Displays the character that follows the backslash. Use this to display a character that is also used in the formatSpec. |
The following examples show typical combinations and the results for example values:
| Value | Display result |
|---|---|
| 0.01 | 0 |
| 0.45 | 0 |
| -10.4 | -10 |
| 0 | 0 |
| 1.2 | 1 |
| 100.253 | 100 |
| 1000.245 | 1000 |
| 123823.995 | 123824 |
| 1238230.904 | 1238231 |
| Value | Display result |
|---|---|
| 0.01 | 0.0 |
| 0.45 | 0.5 |
| -10.4 | -10.4 |
| 0 | 0.0 |
| 1.2 | 1.2 |
| 100.253 | 100.3 |
| 1000.245 | 1000.2 |
| 123823.995 | 123824.0 |
| 1238230.904 | 1238230.9 |
| Value | Display result |
|---|---|
| 0.01 | 0.010 |
| 0.45 | 0.450 |
| -10.4 | -10.400 |
| 0 | 0.000 |
| 1.2 | 1.200 |
| 100.253 | 100.253 |
| 1000.245 | 1000.245 |
| 123823.995 | 123823.995 |
| 1238230.904 | 1238230.904 |
| Value | Display result |
|---|---|
| 0.01 | 0.0000 |
| 0.45 | 0.4500 |
| -10.4 | -10.4000 |
| 0 | 0.0000 |
| 1.2 | 1.2000 |
| 100.253 | 100.2530 |
| 1000.245 | 1000.2450 |
| 123823.995 | 123823.9950 |
| 1238230.904 | 1238230.9040 |
| Value | Display result |
|---|---|
| 0.01 | 1% |
| 0.45 | 45% |
| -10.4 | -1040% |
| 0 | 0% |
| 1.2 | 120% |
| 100.253 | 10025% |
| 1000.245 | 100025% |
| 123823.995 | 12382400% |
| 1238230.904 | 123823090% |
| Value | Display result |
|---|---|
| 0.01 | 1.00% |
| 0.45 | 45.00% |
| -10.4 | -1040.00% |
| 0 | 0.00% |
| 1.2 | 120.00% |
| 100.253 | 10025.30% |
| 1000.245 | 100024.50% |
| 123823.995 | 12382399.50% |
| 1238230.904 | 123823090.40% |
| Value | Display result |
|---|---|
| 0.01 | 0 |
| 0.45 | 0 |
| -10.4 | -10 |
| 0 | 0 |
| 1.2 | 1 |
| 100.253 | 100 |
| 1000.245 | 1,000 |
| 123823.995 | 123,824 |
| 1238230.904 | 1,238,231 |
| Value | Display result |
|---|---|
| 0.01 | 0.00 |
| 0.45 | 0.45 |
| -10.4 | -10.00 |
| 0 | 0.00 |
| 1.2 | 1.20 |
| 100.253 | 100.25 |
| 1000.245 | 1,000.25 |
| 123823.995 | 123,824.00 |
| 1238230.904 | 1,238,231.90 |
| Value | Display result |
|---|---|
| 0.01 | 1e-2 |
| 0.45 | 4.5e-1 |
| -10.4 | -1.000000e+1 |
| 0 | 0.000000e+0 |
| 1.2 | 1.200000e+0 |
| 100.253 | 1.002500e+0 |
| 1000.245 | 1.000250e+3 |
| 123823.995 | 1.238240e+6 |
| 1238230.904 | 1.238232e+6 |
| Value | Display result |
|---|---|
| 0.01 | £0.00 |
| 0.45 | £0.45 |
| -10.4 | £-10.00 |
| 0 | £0.00 |
| 1.2 | £1.20 |
| 100.253 | £100.25 |
| 1000.245 | £1,000.25 |
| 123823.995 | £123,824.00 |
| 1238230.904 | £1,238,231.90 |
Data formats