/text/scalc/guide/format_value_userdef.xhp numbers;user-defined formatting formatting; user-defined numbers number formats; millions format codes; user-defined number formats mw changed "numbers;" User-defined Number Formats You can define your own number formats to display numbers in %PRODUCTNAME 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