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
   307   308   309   310   311   312   313   314   315   316   317