Formatos de número definidos polo usuario

You can define your own number formats to display numbers in Collabora Office 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. Prema en Aceptar.

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

Número	.#,, "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