apply the number number format excel
Apply a custom number format. Select the cell or range of cells that you want to format. On the Home tab, under Number, on the Number Format pop-up menu, click Custom. 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. On the Home tab, under Number, on the Number Format pop-up menu, click Custom. 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. Apply a custom number format. Select the cell or range of cells that you want to format. On the Home tab, under Number, on the Number Format pop-up menu, click Custom. In the Format Cells dialog box, under Category, click Custom. Create a custom number format. On the Home tab, under Number, on the Number Format pop-up menu, click Custom. 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. Create a custom number format. On the Home tab, under Number, on the Number Format pop-up menu, click Custom. 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. Excel 2010 provides a variety of number formats that you can apply to the values (numbers) you enter in a worksheet to make the data easier to interpret. These number formats include currency, accounting, percentage, date, time, fraction, and scientific, as well as a few special formats. Apply a number format via the Number group on the Home tab or the Format Cells dialog box. Use the keystroke shortcut Ctrl+1 to open the Format Cells dialog box. Just keep in mind that the keyboard shortcut is pressing the Ctrl key plus the number 1 key, and not the function key F1. In this case, you can apply number formatting. Select the cells that contain the numbers that are stored as text. How to select cells, ranges, rows, or columns. To select. Do this. A single cell. Click the cell, or press the arrow keys to move to the cell. Click the Number dialog box launcher in the bottom-right corner of the Number group on the Home tab and select the desired format on the Number tab of the Format Cells dialog box. Apply a number format via the Number group on the Home tab or the Format Cells dialog box. For example, if you enter numbers in a workbook, and then format those numbers as text, you won't see a green error indicator appear in the upper-left corner of the cell. In this case, you can apply number formatting. Select the cells that contain the numbers that are stored as text.
Select the cell or range of cells that you want to format. On the Home tab, under Number, on the Number Format pop-up menu, click Custom. 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.