Forum Discussion
Excel Date formatting
Good morning guys, I have a grave issue. In excel I was creating a custom date format in the type "dd.mm.yyyy" to replace the format "dd/mm/yyyy". However upon doing so only two cells out of the list...
Hi,
This is because these dates which have not changed are not real dates, they are in text format!
You have to convert them to real dates before you apply the custom date format!
To do this quickly, please try this trick:
- Highlight them all
- Go to Data >> Data Tools >> Text to Columns
- In Text to Columns window, click Next twice to reach to step 3 of 3
- Select Date, and choose the format of (DMY) as shown in the below screenshot
- Hit Finish
Hope that helps
Thanks so much