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 in Brighton, Sussex.

Related posts:

1. Spreadsheets
2. Submitting Information
3. Formatting and Formulas
4. Basic Calculations
5. Auto Sum

Similar resources you may like

Related posts:

1. Spreadsheets
2. Submitting Information
3. Formatting and Formulas
4. Basic Calculations
5. Auto Sum

Tags

Excel, excel training, excel training sussex, excel tutorial, formatting, formatting numbers, Free, micorsoft office, microsoft, microsoft excel, numbers, Spreadsheets, sussex, Tips, top Tips, Training

Share This Resource

• Digg
• Twitter
• Stumbleupon
• Delicious
• Facebook
• Myspace
• Google
• Technorati
• Newsvine