User-defined Number Formats
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:
-
Select the cells to which you want to apply a new, user-defined format.
-
Choose Format - Cells - Numbers.
-
In the Categories list box select "User-defined".
-
In the Format code text box enter the following code:
0.0,, "Million"
-
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 |