The complete list of Tabular Editor formatting:
| Type | Code | Example |
|---|---|---|
| 0 Decimals with thousands separator | “#,##0.” | 524,456 |
| 2 Decimals with thousands separator | “#,##0.00” | 524,456.00 |
| $ Sign with K for thousands | “$#,##0,.K” | $5,245K |
| millions with separator | “#,##0,,.M” | 5M |
| Percentage with 2 decimals | “0.00%” | 5.25% |
| Percentage with 0 decimals | “0%” | 5% |
| Whole Number | 0 | 122 |
| Percentage Points | 0.0 "pct" | 12.5 pct |
| Scientific format with 2 decimal places | 0.00E+00 | 4.05E+4 |
| Text Format | @ | 4.556565656565775 |
| Custom text plus number format | "your lucky number is:" #,0.00 | your lucky number is: 34.45 |
Comments