How To Enter 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.

Step 1. Right click on the cell where you want to enter date and click Format Cells…
Step 2. Click Number if not selected
Step 3. Click Custom in the Category
Step 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.
Step 5. Click OK

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

Step 1. Right click on the cell where you want to enter date and click Format Cells…
Step 2. Click Number if not selected
Step 3. Click Custom in the Category
Step 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.
Step 5. Click OK

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

Step 1. Right click on the cell where you want to enter date and click Format Cells…
Step 2. Click Number if not selected
Step 3. Click Custom in the Category
Step 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
Step 5. Click OK

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

How To Enter Custom Date Format in Excel Worksheet How To Enter Custom Date Format in Excel Worksheet Reviewed by Mani on February 13, 2013 Rating: 5

No comments:

Powered by Blogger.