When creating or editing a custom calculation (also known as a "Functions"), select Custom in the formatting drop-down and enter the custom format in the field below.
Note: Access to this feature requires additional licensing.
Custom Formatting Examples
You can read Excel’s complete guide about how to specify these formats in their documentation. However, at this time date formatting, color formatting, and hexadecimal conversion are not supported in Explore.
Some of the most common formatting options are shown below. A format code using 0 requires that non-significant zeros be displayed if the number contains fewer digits than specified in the code. A format code using # only displays significant digits, even if there are fewer digits than specified in the code.
Some special characters, such as international currency symbols, must be treated as strings and enclosed in double quotes.
| Format | Result |
| 0 | Integer (123) |
| 00# | Integer zero-padded to 3 places (001) |
| 0 "String" | Integer followed by a string (123 String) ("String" can be replaced with any text string) |
| 0.## | Number up to 2 decimals (1. or 1.2 or 1.23) |
| 0.00 | Number with exactly 2 decimals (1.23) |
| 00#.00 | Number zero-padded to 3 places and exactly 2 decimals (001.23) |
| #,##0 | Number with comma between thousands (1,234) |
| #,##0.00 | Number with comma between thousands and 2 decimals (1,234.00) |
| 0.000,, "M" | Number in millions with 3 decimals (1.234 M) Division by 1 million happens automatically |
| 0.000, "K" | Number in thousands with 3 decimals (1.234 K) Division by 1 thousand happens automatically |
| $0 | Dollars with 0 decimals ($123) |
| $0.00 | Dollars with 2 decimals ($123.00) |
| "€"0 | Euros with 0 decimals (€123) |
| $#,##0.00 | Dollars with comma between thousands and 2 decimals ($1,234.00) |
| $#.00;($#.00) | Dollars with 2 decimals, positive values displayed normally, negative values wrapped in parenthesis |
| 0\% | Display as percent with 0 decimals (1 becomes 1%) |
| 0.00\% | Display as percent with 2 decimals (1 becomes 1.00%) |
| 0% | Convert to percent with 0 decimals (.01 becomes 1%) |
| 0.00% | Convert to percent with 2 decimals (.01 becomes 1.00%) |