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
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
Reviewed by Mani
on
February 13, 2013
Rating:
No comments: