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
   272   273   274   275   276   277   278   279   280   281   282