Forum Discussion
Conversion from European Date Format
I'm using Excel 365. I just copied a column of dates from a web page and pasted them into a column in Excel. The dates on the web page were in the European date format (i.e., dd/mm/yyyy). When pas...
Hello,
For one-off formatting, you can use
1. Select the data
2. CRTL + 1 and select Custom
3. Enter the following: mm/dd/yyyy
4. Click OK
However, if you want to make the changes permanent on your system to have mm/dd/yyyy format, kindly follow the steps below:
1. Type in Control Panel on your system
2. Under Clock and Region, click on Change date, time or number formats
3. Click on Additional Settings
4. Select Date tab
5. In the Date Formats section, clear what you have there and type in dd/mm/yyyy
5. Click OK and OK.
When you return to Excel, all the date with d mm yyyy will turn to dd/mm/yyyy
Do let me know how it pans out after following the steps
For one-off formatting, you can use
1. Select the data
2. CRTL + 1 and select Custom
3. Enter the following: mm/dd/yyyy
4. Click OK
However, if you want to make the changes permanent on your system to have mm/dd/yyyy format, kindly follow the steps below:
1. Type in Control Panel on your system
2. Under Clock and Region, click on Change date, time or number formats
3. Click on Additional Settings
4. Select Date tab
5. In the Date Formats section, clear what you have there and type in dd/mm/yyyy
5. Click OK and OK.
When you return to Excel, all the date with d mm yyyy will turn to dd/mm/yyyy
Do let me know how it pans out after following the steps
