Page 312 - TP_IT_V1.0_C9_flipbpookl
P. 312
Step 5: Select the desired format of the number from the Format list box.
Step 6: Specify the decimal value in the Decimal places to 2 from the Options section.
Step 7: Click on the OK button.
The decimal is added in the number.
Formatting a Range of Cells as Labels
Numbers are not preceded by ‘0’. If you try to put zero before a number, then it will automatically be removed after
moving to the next cell. In order to display zero before a number, it has to be converted into text which can be done
by following 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 Text category from the Category list box.
Step 5: Click on the OK button.
Now, you can add '0' before the number.
310 Trackpad Information Technology (Ver. 1.0)-IX

