Unit 15: Number Formatting Techniques


When you apply the Currency or Accounting number format to data, Excel will format the selected range using the currency format as defined in the setup of your computer. So, for instance, in Australia, the data will be formatted as $ while in the UK, numbers will be formatted as £. The currency formats also give you access to other alternate currencies such as € (Euro).


Excel makes intelligent guesses about the type of data that you enter into a cell – if you enter 12/12/08, Excel will apply date format to that cell. Date formats are generally a combination of day, month and year with a variety of separating symbols. You can apply one of seventeen formats provided for you or create your own custom format using d for day, m for month or y for year.


There are a number of formats to choose from when displaying data as time. The format you choose will depend on whether the data needs to display in excess of 24 hours – for example, is the data a time field in relation to a clock (which ranges from 0:00 to 23:59), or is it a total of hours. You will need to choose a format dependent on how you want to display the data


Custom formats enable you to set the exact appearance that you require for your data. For example, you may want to add text to values to indicate exactly what the value represents, such as kg or lb. You may want to display the name of a day, rather than the date. You may want to separate the $ from the numbers by one space. These can all be achieved using custom formats.

UNIT 15 – Number Formatting Techniques

There aren't any posts currently published in this category.