:

: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 Oblik - Ćelije - Brojevi.

3. :In the Kategorije list box select ""User-defined"".

4. :In the Format code text box enter the following code:

   .#,, ""Million""

5. Klikni OK.

Sljedeća tabela pokazuje efekte zaokruživanja, hiljade delimetara (,), decimalnih delimetara (.) i placeholdera # i 0.

Broj	.#,, ""Million""	.#,, ""Million""	:#,, ""Million""
:10200000	10 miliona	10 miliona	10 miliona
500000	.5 miliona	0.5 miliona	1 milion
:10200000	100 miliona	100 miliona	100 miliona