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 |
| Scientific | numbers are displayed in exponential notation (for example, 1.50E+03 for 1500.31); useful for very large or very small numbers |
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:
