> ## Content Index
> Fetch the complete content index at: https://www.vizney.com/llms.txt
> Use this file to discover other available public pages before exploring further.

# How to use Custom Number Formatting in Tableau
- URL: https://www.vizney.com/how-to-use-custom-number-formatting-in-tableau/
- Published: 2025-07-11T10:34:44.000Z
- Updated: 2025-07-11T10:34:44.000Z
- Author: Yehwan Hwang
- Tags: Knowledge Base

When building visualizations in Tableau, there are times when you need precise control over how numbers are displayed. For example, you may want to simplify figures by displaying them in millions, add specific suffixes, or format negative numbers with parentheses. To meet these needs, Tableau provides the **Custom Number Formatting** feature. With this tool, you can control the visual representation of numbers in a highly intuitive way.

Custom number formatting can be set via the Format pane or directly at the field level. You can specify numeric display patterns according to your requirements. Below are frequently used formats and helpful tips.

---

### Basic Structure

Custom number formats in Tableau allow you to define separate formats for positive numbers, negative numbers, zero values, and null values, using semicolons (`;`) to separate each section.

![](https://kr.vizney.com/content/images/2025/07/Tableau-Format-Structure.png)

---

### Meaning of Key Symbols

The table below explains the meaning of each formatting symbol:

| Symbol | Meaning                                   | Example               | Description                    |
| ------ | ----------------------------------------- | --------------------- | ------------------------------ |
| #      | Displays a digit only if one exists       | 12 → ### → 12         | Zeroes are not shown           |
| 0      | Displays a digit or a zero if none exists | 12 → 000 → 012        | Forces fixed digit width       |
| ,      | Thousands separator or unit scaling       | 1,200 → #,##0, → 1.2  | Adds commas or scales value    |
| .      | Decimal point                             | 2 → 0.00 → 2.00       | Controls decimal places        |
| ;      | Conditional separator                     | #,##0;(#,##0)         | Distinguishes formats          |
| %      | Percentage format                         | 0.5 → 0.0% → 50.0%    | Multiplies number by 100       |
| "      | Literal text wrapper                      | 5 → 0"hours" → 5hours | Adds text before/after numbers |

While format codes like `Y`, `M`, `D` exist for date-style formatting, they are rarely used. For converting numbers to dates, it’s generally better to use calculated fields instead.

Curious about how number-to-date formatting works? See our post below for details.

[Why Is Serial Number 1 Dated December 31, 1899?When converting a date to a number in Excel, Google Sheets or Tableau, you’ll notice that the value 1 represents a specific point in time. In Excel, that number corresponds to January 1, 1900, but in Google Sheets and Tableau, it points to December 31, 1899\. Why do the same![](https://storage.ghost.io/c/6a/50/6a50f03c-1922-4e90-bf18-c5abd0f819d4/content/images/icon/vizney_icon_b_1.0-19.png)VizneyYehwan Hwang![](https://storage.ghost.io/c/6a/50/6a50f03c-1922-4e90-bf18-c5abd0f819d4/content/images/thumbnail/photo-1607871583590-10131167f88b)](https://www.vizney.com/why-is-serial-number-1-dated-december-31-1899/)

---

### Basic Format Examples

These are essential building blocks for understanding custom number formatting:

| Format        | Meaning                                     |
| ------------- | ------------------------------------------- |
| #,##0         | Integer with thousands separator            |
| #,##0.00      | Displays two decimal places                 |
| #,##0,,M      | Displays in millions (e.g., 1,000,000 → 1M) |
| #,##0.0%      | Percentage with one decimal place           |
| +#,##0;-#,##0 | Adds + for positive, \- for negative values |

---

### Commonly Used Formats

Below are practical formats often used in real-world dashboards. Adapt them as needed:

| Format                 | Description                                                                 |
| ---------------------- | --------------------------------------------------------------------------- |
| #,##0,,.0M;-#,##0,,.0M | Displays values in millions with one decimal place (e.g., 1,200,000 → 1.2M) |
| ▲0.0%;▼0.0%;"-"        | Visualizes percentage changes using arrows                                  |
| "#"000                 | Displays a sequence with a fixed prefix                                     |
| 🟢;🔴                  | Shows KPI status with green/red emoji indicators                            |

![](https://kr.vizney.com/content/images/2025/07/KPI-Sample.jpg)

⚠️

****Emojis** may render differently across OS and browsers. They may also behave inconsistently in headers or panels, so test before deploying them in production dashboards.