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

