The Number Group in Microsoft Excel 2010
Quick Tip for Microsoft Excel 2010
In Microsoft Excel 2010 Number formats allow you to change the appearance of your figures. For example, if your figures represent money, you can format them to appear with the pound sign and two decimal places.
The Number Group
- Go to the Home tab on the ribbon
- Go to the Number group
The number group options
- Number format
- Currency
- Percentage
- Insert comma in number
- Increase decimal places
- Decrease decimal places
Applying number formats
- Click on the cells you wish to format
- Click on the Number format icon you require
Removing number formats
- Click on the cells you wish to clear the number formats from
- Click on the Number Format drop down
- Select the first option, General No specific format