Skip to main content

Entering Custom Date Format in Excel Worksheet



Suppose you want to enter date as 01/01/01 or 01-01-01 or 1-Jan-2013 in your excel worksheet. You never get date format like that till you change the default date format.

To enter date format as 01/01/01 in your excel worksheet do the following.

1. Right click on the cell where you want to enter date and click Format Cells…
2. Click Number if not selected
3. Click Custom in the Category
4. Below Type erase General and type dd/mm/yy (dd - for date, mm – for month, yy – for last two digit of the year). If you put yyyy instead of yy then full year will appear.
5. Click OK

To enter date format as 01-01-01 in your excel worksheet do the following.

1. Right click on the cell where you want to enter date and click Format Cells…
2. Click Number if not selected
3. Click Custom in the Category
4. Below Type erase General and type dd-mm-yy (dd - for date, mm – for month, yy - for last two digit of the year). If you put yyyy instead of yy then full year will appear.
5. Click OK

To enter date format as 01-Jan-2001 in your excel worksheet do the following.

1. Right click on the cell where you want to enter date and click Format Cells…
2. Click Number if not selected
3. Click Custom in the Category
4. Below Type erase General and type dd-mmm-yyyy (dd - for date, mmm – for month name instead of month number, yyyy- for full year
5. Click OK

The above three date formats are just an example. You can change date format according to you similarly.




Comments