Getting Started Guide

Entering data using the keyboard
Most data entry in Calc can be accomplished using the keyboard.
Entering numbers
Click in the cell and type in the number using the number keys on either the main
keyboard or the numeric keypad.
To enter a negative number, either type a minus (–) sign in front of it or enclose it in
parentheses (brackets), like this: (1234).
By default, numbers are right-aligned and negative numbers have a leading minus
symbol.
Note
If a number beginning with 0 is entered in to a cell, Calc will drop the 0
(for example 01234 becomes 1234).
To enter a number and retain the leading 0, right-click on the cell and choose Format
Cells > Numbers. In the Format Cells dialog, under Options select the required
number of Leading zeros.
The number selected for leading zeros needs to be one higher than the digits in a
number. For example, if the number is 1234, the number entered for the leading zero
will be 5.
Figure 107: Adjusting leading zeros
Entering text
Click in the cell and type the text. Text is left-aligned by default.
Chapter 5 Getting Started with Calc 123