> For the complete documentation index, see [llms.txt](https://dhtmlx-docs.gitbook.io/spreadsheet-user-guide/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://dhtmlx-docs.gitbook.io/spreadsheet-user-guide/number-formatting.md).

# Number Formatting

## Supported number formats

There are 4 number formats your can apply to format numeric values of cells:

1. **Common** - numbers are displayed as is, with no formatting applied (*1415045928*)
2. **Number** - numbers are displayed with tens, hundreds and thousands separated by specified delimiters (*1,415,045,928.00*)
3. **Currency** - together with the **Number** format numbers get the currency sign ($*1,415,045,928.00*)
4. **Percent** - together with the **Number** format numbers get the percent sign (*141,504,592,800.00%*)

![Using various number formats for values of cells](https://849025270-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LP_ft7DF7Cv1-qfbadp%2F-L_MDr-zJ9JoaIkI7xxC%2F-L_I2F_h5Iwa25jnWnxA%2Fnumber_format.png?alt=media\&token=552c793d-9a90-46eb-8dee-633900d69b7b)

## 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:

![Number format button](https://849025270-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LP_ft7DF7Cv1-qfbadp%2F-LaVS-x9ZZR_5D2CtYZj%2F-LaVSIS7Yru8gUH17aMW%2Fnumber_format_button.png?alt=media\&token=76f5902d-8a3f-49cf-9c66-3e26252d6ed1)

* Select the format you want to apply among the suggested options:

![Options of the Number format button](https://849025270-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LP_ft7DF7Cv1-qfbadp%2F-LaVJ1G1CyR6kwPbb1Eq%2F-LaVJf69PPOGX5jwl6Qu%2Fnumber_format_options.png?alt=media\&token=2f2400e6-379b-42a4-abde-0aea4fbd3864)