There aren't any posts currently published in this category.
Unit 15: Number Formatting Techniques
USING ALTERNATE CURRENCIES:
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.