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
To learn more about Number Groups and to see how we can help your organisation improve their performance with Microsoft Excel give us a call 020 8203 1774
