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:
-
Select the cells to which you want to apply a new, user-defined format.
-
Choose Format - Cells - Numbers.
-
In the Categories list box select "User-defined".
-
In the Format code text box enter the following code:
0.0,, "milljón"
-
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 |