\<bookmark_value\>numbers; user-defined formatting in tables\</bookmark_value\>\<bookmark_value\>formatting; user-defined numbers\</bookmark_value\>\<bookmark_value\>number formats; millions\</bookmark_value\>

User-defined Number Formats

You can define your own number formats to display numbers in \<item type=\"productname\"\>LibreOffice\</item\> 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 \<emph\>Format - Cells - Numbers\</emph\>.

3. In the \<emph\>Categories\</emph\> list box select "User-defined".

4. In the \<emph\>Format code\</emph\> 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.

Number	.#,, "Million"	0.0,, "Million"	#,, "Million"
10200000	10.2 Million	10.2 Million	10 Million
500000	.5 Million	0.5 Million	1 Million
100000000	100. Million	100.0 Million	100 Million