Home » Resources » Excel 2007 Tutorial » Formatting Numbers

A number is never just a number! Numbers can represent currency, percentages, dates, times and a range of other things. We may also want to display a certain number of decimal points or other aspects of the way our numbers appear on a spreadsheet.

The “Number” section of the Excel ribbon provides a range of options which you can choose from in the drop down menu bar and even more if you select the “More Number Formats” button at the bottom.

The Number formatting section is located in the middle of the ribbon. Simply highlight the cell or cells containing the numbers you want to format, and then select the correct formatting option from the “Number” drop-down list.

Once you have mastered these skills you will be ready to attend our Advanced Excel Course, and really advanced might want to try VBA for Excel.

Similar resources you may like

1. Submitting Information
2. Formatting and Formulas
3. Auto Sum
4. Customising Borders and Cell Size
5. Excel Functions

Tags

Excel, Excel 2007 Tutorial, excel training, excel tutorial, formatting, formatting numbers, Free, micorsoft office, microsoft, microsoft excel, numbers, Spreadsheets, Tips, top Tips, training

Share This Resource

This entry was posted by Alistair Wylie on Wednesday, May 6th, 2009 at 12:40 pm and is filed under Excel 2007 Tutorial. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.