Forum Discussion

aldayne henry's avatar
aldayne henry
Copper Contributor
Oct 03, 2018

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 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

excel

2 Replies

  • Haytham Amairah's avatar
    Haytham Amairah
    Silver Contributor
    Oct 03, 2018

    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

Resources