It is easy to display dates as 10-Apr-2012, or any other format you prefer
Q I have updated from Excel 97 to the 2010 edition. I favour the date format of 10-Apr-2012 and Excel files created using my earlier version continue to allow this form where it was previously specified. However, when I create a new column for dates and go to change cell formatting, Excel 2010 does not offer this format as an option. I have tried Excel help but I have not been able to find what I am looking for. How can I obtain this date format?
A Excel does include a large number of different options for formatting text and numbers in cells but it may not be immediately obvious that you can also customise formats to suit your needs.
Highlight the relevant cells or columns and then click the Format button in the Cells section of the ribbon before selecting Format Cells from the menu. Make sure that you are on the Numbers tab and select the Custom option from the list to the left side of the dialogue box. In the Type box to the right, type dd-mmm-yyyy and click OK. This will ensure that your dates are displayed with a two-digit day, a three-letter month and four-digit year, all separated by dashes.
Updating your subscription status