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.
Formatbutton in the toolbar.
Formatselect to pick the formatting to apply to the column.