Question

How do you format a number on an excel spreadsheet?

Answer 1

Answer:

On the Home tab, in the Number group, click More Number Formats at the bottom of the Number Format list  Format Number box .

In the Format Cells dialog box, under Category, click Custom.

In the Type list, select the built-in format that most resembles the one that you want to create. For example, 0.00.

The number format that you select appears in the Type box.

In the Type box, modify the number format codes to create the exact format that you want. For example, 000-000-0000.

Your changes will not alter the built-in format. Instead, your changes create a new custom number format.

When you have finished, click OK.

Answer 2

Answer:

Create a custom number format

On the Home tab, in the Number group, click More Number Formats at the bottom of the Number Format list Format Number box .

In the Format Cells dialog box, under Category, click Custom.

In the Type list, select the built-in format that most resembles the one that you want to create. For example, 0.00.

The number format that you select appears in the Type box.

In the Type box, modify the number format codes to create the exact format that you want. For example, 000-000-0000.

Your changes will not alter the built-in format. Instead, your changes create a new custom number format.

When you have finished, click OK.

Apply a custom number format

Select the cell or range of cells that you want to format.

On the Home tab, in the Number group, click More Number Formats at the bottom of the Number Format list Format Number box .

In the Format Cells dialog box, under Category, click Custom.

At the bottom of the Type list, select the built-in format that you just created. For example, 000-000-0000.

The number format that you select appears in the Type box.

Click OK.

Delete a custom number format

On the Home tab, in the Number group, click More Number Formats at the bottom of the Number Format list Format Number box .

In the Format Cells dialog box, under Category, click Custom.

In the Type list, select the custom number format, and then click Delete.