Number formatting
Supported number formats
There are several number formats you can apply to format numeric values of cells:
| Common | numbers are displayed as is, with no formatting applied |
| Number | numbers are displayed with tens, hundreds and thousands separated by specified delimiters |
| Currency | numbers are displayed with the currency sign ($) |
| Percent | numbers are displayed with the percent sign (%) |
| Date | numbers are displayed as dates in the specified format |
| Time | numbers are displayed as times in either 12 or 24-hour format |
| Text | numbers are displayed as text and exactly as you type them |
How to set format
Follow the steps below to apply a particular number format to Spreadsheet data via the toolbar:
- Select a cell or several cells that you want to format.
- Click the Number format button:
- Select the format you want to apply among the suggested options:
