:

: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


Please support us!