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.Format
button in the toolbar.#
sign. Format
select to pick the formatting to apply to the column.