How can I change the default date format?

Solution 1:

By default Excel starts all new workbooks without formatting. This means you have to tell Excel how you want the data formatted.

To achieve what you ask, you will need to format the column to the date format you want then save the file. You have to options to save the file:

1. If you do not want this formatting applied to ALL new workbooks, save the formatted workbook as a template (xltx) or regular file. Each time you use this file it will be formatted for you to paste the data.

2. If you want it to be the starting point for ALL new workbooks, then save the template as Book.xltx in the XLSTART folder. This folder is typically located at C:Program Files\Microsoft Office\Office14\XLSTART.

Now you have a formatted file to use. When you open the file and paste the data, paste only the values and it will format it the way you've chosen.

Solution 2:

It completely depends on your system date and time format:

1. Go to Control Panel.
2. Click on "Region and Language".
3. Click on "change date, time and number format".
4. Set "short date", "long date", "short time" and "long time".