Introduction
Text Documents (Writer)
HTML Documents (Writer Web)
Spreadsheets (Calc)
Presentations (Impress)
Drawings (Draw)
Database Functionality (Base)
Formulae (Math)
Charts and Diagrams
Macros and Scripting
Office Installation
Common Help Topics
OneOffice Logo

User-Defined Number Formats

You can define your own number formats to display numbers in 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"

  1. 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