Entering data into a sheet
- Selecting cells
- Selecting columns and rows
- Inserting columns and rows
- Deleting columns and rows
- Working with sheets
- Entering data into a sheet
- Printing
Entering numbers
Select the cell and type in the number using either the top row of the keyboard or the numeric keypad.
To enter a negative number, type a minus (–) sign in front of it or enclose it in brackets ( ).
By default numbers are right-aligned and negative numbers have a leading minus symbol.
Entering text
Select the cell and type the text. Text is left-aligned by default.
Entering numbers as text
If a number is entered in the format 01481, Calc will drop the leading 0. To preserve the leading zero, in the case of telephone area codes for example, precede the number with an apostrophe, like this: '01481. However, the data is now regarded as text by Calc. Formulas and functions will treat the entry like any other text entry, which typically results in it being a zero in a formula, and being ignored in a function.
Entering dates and times
Select the cell and type the date or time. You can separate the date elements with a slant (/) or a hyphen (-) or use text such as 10 Oct 03. Calc recognizes a variety of date formats. You can separate time elements with colons such as 10:43:45.
Content on this page is licensed under the Creative Common Attribution 3.0 license (CC-BY). |