| sidebar_label | Number formatting |
|---|---|
| title | Number Formatting Guide |
| description | You can study the user guide about number formatting in the documentation of the DHTMLX JavaScript Spreadsheet library. Browse developer guides and API reference, try out code examples and live demos, and download a free 30-day evaluation version of DHTMLX Spreadsheet. |
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 |
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:
