# Column Formatting

Mito lets you change the format of numeric columns. This only changes the displayed values in the columns, and does not edit the underlying data.

### Changing the Formatting of Number Columns <a href="#changing-the-formatting-of-a-column-s" id="changing-the-formatting-of-a-column-s"></a>

To change the format of number columns:

1. Select the columns you want to change the format of.&#x20;
2. Select the **Number** dropdown from the toolbar.
3. Select the format you want to change to:
   1. `Default`: Separate every three numbers with commas. It displays integers with no decimal places (1,234), and floats with one decimal place (1,234.5).
   2. `Plain Text`: Don't use commas to separate numbers and display all of the decimal places that exist in the raw data (1234.5678).
   3. `Currency`: Display numbers using a $. For example, -5000 is displayed as -$5,000.00).
   4. `Accounting`: Display numbers using a $ and use parentheses to identify negative numbers. For example, -5000 is displayed as ($5,000.00).
   5. `Percentage`: Display the number as a percentage.
   6. `Scientific Notation`: Display numbers in scientific notation. For example, 9,000,000,000 will be displayed as 9.00e+9.
4. If you want to change the number of decimals displayed in the column, click the **Less** and **More** buttons in the toolbar.

<figure><img src="/files/9Y1w562falVEer6SgaaQ" alt=""><figcaption><p>Select the number formatting from the dropdown</p></figcaption></figure>

<figure><img src="/files/9Oatz71rSDRXkTrUuT7M" alt=""><figcaption><p>Change the number of decimals displayed</p></figcaption></figure>

#### Using the Column Control Panel <a href="#using-the-column-control-panel" id="using-the-column-control-panel"></a>

You can also change a columns format by opening the column control panel:

1. Clicking on the type icon in the column header.
2. Use the **Format** select to pick the formatting to apply to the column.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.trymito.io/how-to/formatting/column-formatting.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.