Labels

Friday 22 July 2011

Shortcut Key: CTRL + SHIFT + 3 – Convert format to date

Automatically convert a cell to date format using the keys CTRL + SHIFT + 3. Excel saves date values as serial numbers (e.g. 39994 is 30 June 2009, 39993 is 29 June 2009 etc). Sometimes when you enter a date Excel shows the serial number instead of the date format. Furthermore, if you enter a date as 30/06/2009 Excel may also show the date in this format.

My personal preference is for dates to be shown as mm ddd yy (i.e. 30-Jun-09). You can quickly convert a cell to this format (or you default date format) by pressing CTRL + SHIFT + 3.Then using the shortcut it becomes (make sure you select the cell(s) you want change and press CTRL + SHIFT + 3):







No comments:

Post a Comment