Mito
Search…
Mito
Mito Docs
Getting Started
Installing Mito
Core Concepts
Feature Reference
Creating a Mitosheet
Importing Data
Graphing
Pivoting/Group By
Filter out Rows
Summary Statistics
Type Changes
Spreadsheet Formulas
Editing Individual Cells
Combining Dataframes
Sort Data
Split Text to Columns
Deleting Columns
Deleting Rows
Column Headers
Deduplicate
Fill NaN Values
Transpose
Unpivot (Melt) a Dataframe
Formatting
Exporting Data
Using the Generated Code
View in Mito Button
Upgrading Mito
How To
Pass a dataframe into Mito
Create a line chart of time series data
Delete Columns with Missing Values
Exploratory Data Analysis
Create a Bar Chart
Split a column on delimiter
Misc
Videos
Release Notes
FAQ
Terms of Service
Privacy Policy
Powered By GitBook
Formatting
This documentation explains how to use Mito's formatting features to change the display of a column without effecting the underlying data.
Changing the format of three numeric columns
Mito lets you change the format of numeric columns. Its important to note that changing the format of the column only changes the display of the data, not the underlying data.

Formatting Options

  • 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).
  • Plain Text: Don't use commas to separate numbers and display all of the decimal places that exist in the raw data (1234.5678).
  • Accounting: Display numbers using a $ and use parentheses to identify negative numbers. For example, -5000 is displayed as ($5,000.00).
  • 0, 1, 2, 3, or 4 decimal places: Select the number of decimal places to display.
  • Percentage: Display the number as a percentage.
  • Using K, M, and B for large numbers: Make it easier to parse large numbers by using K to represent thousands, M to represent million, and B to represent Billion. For example, 9,000,000,000 will be displayed as 9B.
  • Scientific Notation: Display numbers in scientific notation. For example, 9,000,000,000 will be displayed as 9.00e+9.

Changing the Formatting of a Column(s)

There are two ways to change the format of a numeric column: by using the format button in the Mito toolbar, or by using the format selector in the column control panel.

Using the Format Button in the Toolbar

Using the formatting button in the toolbar is simple, just:
  1. 1.
    Select all of the columns you want to update the formatting of (you can select multiple columns at once by holding down Command on Mac or Control on Windows).
  2. 2.
    Click on the Format button in the toolbar.
  3. 3.
    Select the formatting to apply to the selected columns.
Note: If any of the columns you've selected are not numeric, those columns will not have formatting applied.
Using the format button in the toolbar to change the formatting of 3 numeric columns

Using the Column Control Panel

The other way of changing a column's formatting is to use the column control panel.
  1. 1.
    Open the column control panel by double clicking on the type icon in the column header. In this example, the type icon is the # sign.
  2. 2.
    Use the Format select to pick the formatting to apply to the column.
Using the column control panel to change the formatting of one column
Feature Reference - Previous
Unpivot (Melt) a Dataframe
Next - Feature Reference
Exporting Data
Last modified 2mo ago
Copy link
Outline
Formatting Options
Changing the Formatting of a Column(s)