Applications

 

Help Sections:

General

Writer

Impress

Math

Draw

Calc

Base

Basic

Using Rounded Off Numbers

In OpenOffice.org Calc, all decimal numbers are displayed rounded off to two decimal places.

To change this for selected cells

1. Mark all the cells you want to modify.

2. Choose Format - Cells and go to the Numbers tab page.

3. In the Category field, select Number. Under Options, change the number of Decimal places and exit the dialog with OK.

To permanently change this everywhere

1. Choose Tools - Options - OpenOffice.org Calc.

2. Go to the Calculate page. Modify the number of Decimal places and exit the dialog with OK.

To calculate with the rounded off numbers instead of the internal exact values

1. Choose Tools - Options - OpenOffice.org Calc .

2. Go to the Calculate page. Mark the Precision as shown field and exit the dialog with OK.

Index

numbers, rounded off

rounded off numbers

exact numbers in $[officename] Calc

decimal places, showing

changing,number of decimal places

values,rounded in calculations

calculating,rounded off values

numbers, decimal places

precision as shown

rounding precision

tables in spreadsheets, values as shown

This help text is published from the OpenOffice-Help files under the Public Documentation License 1.0.