# Formatting Text

For text, there are these formats available:

* _Common_ - whenever possible, the value will be formatted as a number; otherwise as text
* _Text_ - no special formatting, the text will be displayed as is

To apply the default text format to a cell value:

1\) Select a cell or a range of cells to format.\
&#x20;2\) Click the **Text format** button in the Number section to open a drop-down list with number formats.\
&#x20;3\) Choose the necessary format that will be applied to the selected cells.\


## Custom Text Format

You can customize the predefined formats by adding color for the text or adding some static text for cell values.

To customize a predefined text format:

1\) Select a cell or a range of cells to apply custom format to.\
&#x20;2\) Click the format button in the **Number** section and select the **Custom** option.\
&#x20;3\) Select **Custom**.\
&#x20;4\) Add a color before "@", e.g. `[red]` or add _"Some text"_ to the line.\


![Custom Date Format](https://3310388157-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LEEOWDArdNNgipO8mVJ%2F-M1QTytWZW7Z_ODoZKxZ%2F-M1QTzTStoOZxQ6pP4E6%2Fcustom_text_format.png?generation=1583156558546395\&alt=media)

An example of a format line:

`[blue]@ "Some extra text here"`

5\) To apply the new format, click **Save**.
