Excel: Formatting Dates

Dates can be formatted to display in different ways in Excel, it could be that you want the month displayed as a number, shortened month or in full. It could also be you want the day of the week displayed. You can choose how you want it to appear.

It could also be that when your enter a date you change your mind and then want to put a number in instead rather than the date, Excel is quite clever and would have set the formatting of the cell so when you enter a number it appears as a date. So in this tutorial I show you how to fix that too.