Six Easy Ways to Format Numbers In Excel

Here are some basic guidelines to help you learn how to format numbers in Excel 2007. Most of the stuff is easier than it looks.

 

If you need to, download the pdf at the bottom of each set of instructions to help you learn with pictures. You can also file it and refer to it later on.

 

If you’d like these to be sent to you automatically through email, click here:

Subscribe to admins4admins.com by Email

 

Our mission is to help you learn Excel easily and as fast as you can. We know you don’t have the time to sit through an entire course. These are designed to help you pick up each piece as you need it.

 

These steps are our best suggestions. If you know better shortcuts, shoot us an email! No stress. Have fun!

 

How to Use the Number Format

1. Highlight the cells you want to format as numbers.

2. Click the “Home” tab.

3. Click the small arrow next to “Number”.

4. Click “Number”.

5. Click the format you want the numbers to appear in.

6. Click “OK”.

7. The data will be displayed as numbers.

How to Use the Number Format (PDF)

 

 

How to Display Numbers as Fractions

1. Highlight the numbers you want to format as fractions.

2. Click on the “Home” tab.

3. In the “Number” area click on the “Format” menu.

4. Click on “Fraction”.

5. The numbers will be converted to fractions.

How to Display Numbers as Fractions (PDF)

 

 

 

How to Display Numbers as Currency

1. Highlight the numbers you want to format as currency.

2. Click on the “Home” tab.

3. In the “Number” area click on the arrow next to “Accountancy Number Format”.

4. Pick a currency.

5. The numbers will be converted to that currency.

How to Display Numbers as Currency (PDF)

 

 

 

How to Display Numbers as Percentages

1. Highlight the numbers you want to format as percentages.

2. Click on the “Home” tab.

3. In the “Number” area click on “Percent Style”.

4. The numbers will convert to percentages.

How to Display Numbers as Percentages (PDF)

 

 

How to Format Numbers in Non-Adjacent Cells

1. Highlight the first set of cells.

2. Hold down Ctrl and highlight all of the other sets of cells.

3. Click the “Home” tab.

4. Click the small arrow next to “Number”.

5. Click “Number”.

6. Click the format you want the numbers to appear in.

7. Click “OK”.

8. The format of the data will change.

How to Format Numbers in Non-Adjacent Cells (PDF)

 

 

How to Format Numbers in One Cell

1. Highlight the cell or adjacent cells in which you want to change the number format.

2. Click the “Home” tab.

3. Click the small arrow next to “Number”.

4. Click “Number”.

5. Click the format you want the numbers to appear in.

How to Format Numbers in One Cell or Adjacent Cells (PDF)