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. 2) Click the Text format button in the Number section to open a drop-down list with number formats. 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. 2) Click the format button in the Number section and select the Custom option. 3) Select Custom. 4) Add a color before "@", e.g. [red] or add "Some text" to the line.

Custom Date Format

An example of a format line:

[blue]@ "Some extra text here"

5) To apply the new format, click Save.