Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 74 - 2505_CoreGPT(Podar)_Flipbook_C6
P. 74

    Entering Date or Time

                      To input a date or time, select the cell and type the required information. Use a slash (/) or a
                      hyphen (-) to enter a date (e.g.,  11 Oct 2011) and separate time  elements  with colons
                      (e.g., 11:20:45). The date and time will automatically adjust according to the selected format.

                      To change the date format:
                      Step 1  Right-click on the cell.

                      Step 2  Select the  Format Cells option  from the
                               shortcut  menu.  The  Format Cells dialog  box
                               will appear.

                      Step 3  Choose the  Numbers tab, then select either
                               Date from the Category list.

                      Step 4  Select the desired date format from the Format
                               list.
                      Step 5  Click OK to apply the changes.

                      To change the time format:
                      Step 1  Right-click on the cell.

                      Step 2  Select the  Format Cells option from the
                               shortcut menu. The  Format Cells dialog box
                               will appear.

                      Step 3  Choose the  Numbers tab,  then select either
                               Time from the Category list.

                      Step 4  Select the desired time format from the Format
                               list.
                      Step 5  Click OK to apply the changes.

                     72     Premium Edition-VI

| 69 70 71 72 73 74 75 76 77 78 79 |