User-defined Number Formats

From LibreOffice Help
Jump to: navigation, search

You can define your own number formats to display numbers in LibreOffice Calc.

As an example, to display the number 10,200,000 as 10.2 Million:

  1. Select the cells to which you want to apply a new, user-defined format.
  2. Choose Format - Cells - Numbers.
  3. In the Categories list box select "User-defined".
  4. In the Format code text box enter the following code:
    0.0,, "Million"
  5. Click OK.

The following table shows the effects of rounding, thousands delimiters (,), decimal delimiters (.) and the placeholders # and 0.

Number .#,, "Million" 0.0,, "Million" #,, "Million"
10200000 10.2 Million 10.2 Million 10 Million
500000 .5 Million 0.5 Million 1 Million
100000000 100. Million 100.0 Million 100 Million

Related Topics

Formatting Numbers With Decimals

Cells in Currency Format

Formatting Numbers as Text

Number Format Codes