Page 280 - Trackpad IT-402_Class-IX
P. 280
011
022
033
044
055
Formatting of a Range of Cells as Scientific
To change the numbers as scientific notation, follow the given steps:
Step 1: Select the range of cells with the numeric values.
Step 2: Click on Format → 'Cells...' to open the Format Cells dialog box.
Step 3: Select the Numbers tab.
Step 4: Click on Scientific category.
Step 5: Click on OK button. The values will appear in scientific notation.
Formatting a Range of Cells to Display Date
To change the format of the date to a different type, follow the given steps:
Step 1: Select the range of cells with the numeric values entered as a date.
Step 2: Click on Format → Cells... to open the Format Cells dialog box.
Step 3: Select the Numbers tab.
Step 4: Click on Date category and select the required format of the date.
Step 5: Click on the OK button to see the changes as shown below.
280 Trackpad Information Technology-IX

