User-defined Number Formats/text/scalc/guide/format_value_userdef.xhpnumbers; user-defined formatting in tablesformatting; user-defined numbersnumber formats; millionsformat codes; user-defined number formatsmw copied "format codes;" from shared/01/05020300.xhpUser-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.