| description | data |
|---|---|
| NO Decimals | 135780584.123456 |
| 3 Decimals | 135780584.123456 |
| Comma with 3 dec | 135780584.123456 |
| Date7 | 31/08/2018 |
| Date9 | 31/08/2018 |
| D -T AMPM | 31/08/2018 |
| 01/03/1998 | 31/08/2018 |
| 01-mar-98 | 31/08/2018 |
| 01-mar-1998 | 31/08/2018 |
| 5:16 | 31/08/2018 |
| 5:16 am | 31/08/2018 |
| 5:16:21:00 | 31/08/2018 |
| Percent - two decimals | 135780584.123456 |
| Percent - no decimals | 135780584.123456 |
| Scientific Notation | 135780584.123456 |
| Text | 135780584.123456 |
| Fractions - up to 3 digits (312/943) | 135780584 |
| £12.76 | 135780584.123456 |
| 2 decimals, negative red numbers | -13578.12 |