Excel Basics · ~3 min read

Format Text, Numbers and Dates in Excel

Bold, colors, alignment, number formats, currency, percent and date formats.

Video link coming soon
What you will learn

Step by step

1. Intro

Welcome back. In this lesson, you will make your data look professional: bold headers, colors, alignment, and number formats for currency, percent and dates.

Here is a small sales table. It is correct, but it is plain and hard to read. The prices have no currency, the discounts are decimals, and the dates are strange numbers.

Format Text, Numbers and Dates in Excel: Intro
Intro

2. Font and color

Let's start with the header. Drag across A1 to E1 to select it.

On the Home tab, in the Font group, click Bold. Or press Control and B.

Next, the fill color button, the paint bucket, adds a background color. Click it.

The little arrow next to it opens a palette of more colors, and the letter A button next to that changes the font color.

Format Text, Numbers and Dates in Excel: Font and color
Font and color

3. Alignment

Now alignment. With the header still selected, click Center, to put the text in the middle of the cells.

The other buttons align text to the left or to the right, and the Wrap Text button breaks long text into several lines inside a cell.

Format Text, Numbers and Dates in Excel: Alignment
Alignment

4. Number formats

Now numbers. Select the prices, B2 to B5.

Click the dollar sign button. The numbers become currency, with a dollar symbol and two decimals.

Important: the number inside the cell did not change. Only its appearance did. Formatting never changes the real value.

Now the discounts, E2 to E5. These are decimals, like zero point one. Select them.

Click the percent button, and zero point one becomes ten percent.

The two buttons with the arrows add or remove decimal places. Click Increase Decimal once, then Decrease Decimal to go back.

Format Text, Numbers and Dates in Excel: Number formats
Number formats

5. Dates

Finally, the dates. Excel stores a date as a number, which is why we see these big values. Select D2 to D5.

Press Control, Shift and three. Now the numbers show as proper dates.

These shortcuts exist for the other formats too: Control Shift four for currency, and Control Shift five for percent.

Shortcut: Ctrl + Shift + 3

Format Text, Numbers and Dates in Excel: Dates
Dates

6. Wrap, paint and merge

Now a few more tools. Long text spills over into the cells next to it. Click A9 and type a short note.

Select the cell and click Wrap Text. The text now stays inside the cell, on several lines, and the row grows to fit.

Next, a title for our table. Type Sales report in A7.

Format Painter copies the look of one cell to another. Select the formatted header, click Format Painter, then drag over the title row.

Now, with the title row selected, click Merge and Center. The five cells become one, and the title sits in the middle.

Finally, the letter A with the up arrow makes the font bigger. Click it twice for a real title.

To remove formatting, use the Clear button in the Editing group, then Clear Formats. The data stays, and only the look disappears.

The Number group also has a drop-down box with more formats, such as Long Date, Time and Fraction.

Format Text, Numbers and Dates in Excel: Wrap, paint and merge
Wrap, paint and merge

7. Quick wins

Let's polish the first column. Select the product names and press Control and I for italics.

If you do not like a change, press Control and Z to undo it, just like in any other program.

Format Text, Numbers and Dates in Excel: Quick wins
Quick wins

8. Recap

Let's recap. Bold, fill color, font color and alignment live in the Font and Alignment groups of the Home tab.

Number formats change how values look, not what they are. Use currency, percent and date formats, and the keyboard shortcuts to be faster.

Next time, you will learn to work with rows, columns and borders.

Thanks for watching, and see you in the next lesson.

Format Text, Numbers and Dates in Excel: Recap
Recap
What do you want to learn next? Tell us in the comments on YouTube: your requests decide the next tutorials.

← Previous tutorial: Your First Excel Formulas (Beginner Tutorial)
Next tutorial: Rows, Columns and Borders in Excel (Resize, Insert, Delete) →