User-defined Number Formats

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,, "millj贸n"

  5. Smelltu 谩 '脥 lagi'.

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

N煤mer

.#,, "millj贸n"

0.0,, "millj贸n"

#,, "millj贸n"

10200000

10.2 millj贸n

10.2 millj贸n

10 millj贸n

500000

.5 millj贸n

0.5 millj贸n

1 millj贸n

100000000

100. millj贸n

100.0 millj贸n

100 millj贸n


Please support us!