Excel Date formatting

[aldayne henry]

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 changed and the rest remains the same. I do not know what is happening, I checked to see if the cells were locked but they weren't. They are just not changing to the custom date format I set. Please help I need it urgently

[#2]

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

[#3]

Thanks so much