Microsoft Excel 
ITTraining@sgul.ac.uk Page 25 St. George’s Information Services 
PRACTICE EXERCISE 
Number Formatting 
Tasks: Completed: 
 Before starting this exercise you MUST have completed all of the topics in 
the chapter Number Formatting… 
 
 
Open the workbook called PE_Number Formatting.xlsx (it can be found 
in the same folder as the student files)  
 
On the Cargo worksheet, apply formatting to the dates and figures so that 
they appear as shown in sample A on the next page 
This will involve applying a date format, thousands separator, setting the 
number of decimals and applying the currency format... 
 
 
On the Purchases worksheet, apply formatting so that the figures appear 
as shown in sample B on the following page 
The currency formats should be $, € Euro (€ 123), R English (South Africa) 
and ETB Amharic (Ethiopia) respectively. You’ll need to widen the columns 
a little to make room for the characters added by the formatting... 
 
 
Use the Save As command to save the workbook as PE_Number 
Formatting (Completed).xlsx 