|
|
|
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?
John Tanner
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.
Article tags
Related articles
Change the width and height of more than one column or row at a time
Try our secret Office tricks to get more from the document, spreadsheet and presentation tools and programs you use most often
It is possible to set a default font for every time you make a new spreadsheet in Microsoft Excel 2003, 2007 and 2010
Content Recommendation
Q.Why is Windows Backup skipping files?
Q.Why do my scanned documents display gibberish?
Q.How can I convert MTS files to edit in Windows Movie...
Updating your subscription status 
Stop the government spying on you
