Page 277 - Computer - 9(A&B)
P. 277
Formatting a Range of Cells to Display Date or Time
It is important to understand that date and time in Calc are stored and treated internally as numbers. However,
you can format the display of a date and time to one of the available formats. To enter a date, you must separate
the date elements with a slash (/) or a hyphen (–). The date format automatically changes to the selected format
used by Calc. When you enter a time, the time format automatically changes to the selected format used by Calc.
In both the cases, Calc recognizes the data you entered as date or time and not as simple text or numbers.
The following are valid date or time formats:
v 05/10/2021 v 05 Oct 2021 v 12:23 AM
v 05-10-2021 v 12:23:35
To format a range of cells as date or time:
Step 1: Select the text which is to be formatted.
Step 2: Click on Format menu and select Cells option. The Format Cells dialog box appears with the Number
tab selected in it.
Step 3: Select Date or Time from the Category list. To quickly enter current date,
Step 4: Select the desired date or time format from the press Ctrl+ ;
Format list. To quickly enter current time,
press Ctrl+Shift +;
Step 5: Click the OK button.
The text in the range of cells will be displayed accordingly.
139
139