Page 242 - IT_Play_V1.0 Class9
P. 242

Now, selected cells will display the values with the specified number of decimal places.










              Formatting a Range of Cells to be Seen as Labels


              In telephone number, the STD code always starts with 0. But while entering the telephone number as numeric
              data, ‘0’ disappears from the first position/place. To overcome this:

              Step 1:  Select a cell or a range of cells.
              Step 2:  Click on the Format menu from the Menu bar.

              Step 3:  Select the Cells option from the drop-down menu. The Format Cells dialog box appears on the screen.
              Step 4:  Click on the Numbers tab.

              Step 5:  Select the desired Text option from the Category list. To ensure the phone numbers are treated as text.
              Step 6:  Click on the OK button.


                       2
                                                                      4



                       3


                                                                      5
                       1






                                                                                                            6


              Now, selected cells will display phone numbers in a consistent and readable manner.












              Formatting of a Cell Range as Scientific

              To format a range of cells as scientific, follow these steps:
              Step 1:  Select a cell or a range of cells.

              Step 2:  Click on the Format menu from the Menu bar.
              Step 3:  Select the Cells option from the drop-down menu. The Format Cells dialog box appears on the
                      screen.



                240     Information Technology Play (Ver 1.0)-IX
   237   238   239   240   241   242   243   244   245   246   247