Question

Write the steps to format data in worksheet

Answer 1

Answer:

Explanation:

Select an empty cell.

On the Home tab, in the Number group, click the arrow next to the Number Format box, and then click Text.

Type the numbers that you want in the formatted cell. Numbers that you entered before you applied the Text format to the cells must be entered again in the formatted cells.

Answer 2

Explanation:

Formatting Worksheets

1.Select the cells for which you want to change the number format.

2. Select Format_Cells and select the Number tab.

3.Select a category for the number format from the Category list.

4.Type a number format or select a format type from the Type combo box.

5.You can type a built-in format or a custom format.

6.Click OK.