Excel Basics – Format Cells in Excel


Format Cells

When we format cells in Excel, we change the appearance of a number without changing the number itself. We can apply a number format (0.5, $0.50, 50%, etc) or other formatting (alignment, font, border, etc).

1. Enter the value 0.5 into cell B4.


By default, Excel uses the General format (no specific number format) for numbers. To apply a number format, use the ‘Format Cells’ dialog box.

2. Select cell B4.

3. Right click, and then click Format Cells (or press + ).


The ‘Format Cells’ dialog box appears.

4. For example, select Currency.

Format Cell Dialog Box

Note: Excel gives you a life preview of how the number will be formatted (under Sample).

5. Click OK.

Formatted Cell

Cell B4 still contains the number 0.5. We only changed the appearance of this number. The most frequently used formatting commands are available on the Home tab.

6. On the Home tab, in the Number group, click the percentage symbol to apply a Percentage format.

Percentage Format

7. On the Home tab, in the Alignment group, center the number.

Center Alignment

8. On the Home tab, in the Font group, add outside borders and change the font color to Red.

Borders and Font Color


New Format

Next Chapter: Find & Select

Love this article?


Please enter your comment!
Please enter your name here