More Date Formats

I think most of you enter the date into the excel by entering dates before the month. As an example let's take you want to enter 12th of November into the excel. We can enter it as 12/11 or 11/12. What is the correct method? See below picture cell b2 and d2 shows that results respectively. 

You can see cell d2 shows the correct date.
Now right click on cell d2 and select format cells. Select Custom on popup box.

There is a combo box named type. Enter bellow mentioned formats one at once into that box.

1. d
2. dd
3. ddd
4. m
5. mm
6. mmm
7. mmmm
8. yy
9. yyy
10. dd,ddd
11. yy-mmm-dd,ddd

See changes on the date and practice. 

Save Your Macro

I think all of you were recorded your first macro. Follow below steps to save your macro. To save your file with macro save as option on file. Then select "Excel Macro-Enabled workbook". Click save.