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,, "Million"

  5. Click OK.

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

แƒ แƒ˜แƒชแƒฎแƒ•แƒ˜

.#,, "แƒ›แƒ˜แƒšแƒ˜แƒแƒœแƒ˜"

0.0,, "แƒ›แƒ˜แƒšแƒ˜แƒแƒœแƒ˜"

#,, "แƒ›แƒ˜แƒšแƒ˜แƒแƒœแƒ˜"

10200000

10.2 แƒ›แƒ˜แƒšแƒ˜แƒแƒœแƒ˜

10.2 แƒ›แƒ˜แƒšแƒ˜แƒแƒœแƒ˜

10 แƒ›แƒ˜แƒšแƒ˜แƒแƒœแƒ˜

500000

.5 แƒ›แƒ˜แƒšแƒ˜แƒแƒœแƒ˜

0.5 แƒ›แƒ˜แƒšแƒ˜แƒแƒœแƒ˜

1 แƒ›แƒ˜แƒšแƒ˜แƒแƒœแƒ˜

100000000

100. แƒ›แƒ˜แƒšแƒ˜แƒแƒœแƒ˜

100.0 แƒ›แƒ˜แƒšแƒ˜แƒแƒœแƒ˜

100 แƒ›แƒ˜แƒšแƒ˜แƒแƒœแƒ˜


Please support us!