Page 313 - TP_IT_V1.0_C9_flipbpookl
P. 313
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 the Format → Cells option from the Menu bar.
The Format Cells dialog box opens.
Step 3: Select the Numbers tab.
Step 4: Click on the Scientific category from the Category list box.
Step 5: Select the desired format of the number from the Format list box.
Step 6: Click on the OK button.
The values will appear in scientific notation.
Formatting a Range of Cells to Display Date
In a spreadsheet, by default the date format is in American Format, where mm-month, dd-date, yyyy-year. However,
this default format can vary depending on the regional settings of your software and operating system. The date
12/09/2023 means that it is the 09th day of December 2023. In a spreadsheet application, the user can change this
Date in many different formats. 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 the Format → Cells option from the Menu bar.
The Format Cells dialog box opens.
Step 3: Select the Numbers tab.
Step 4: Click on the Date category from the Category list box.
Step 5: Select the desired format of the number from the Format list box.
Step 6: Click on the OK button.
Electronic Spreadsheet 311

