Apr 12 2021 03:56 AM
Apr 12 2021 04:09 AMSolution
@Debasmita23 When you imported the dates, Excel did not recognise 31/03 as a valid date. On the other hand, 04/01 was recognised, it was "translated" to April 1, where the data probably represents 4 January. Hence, column A became a mix of valid dates (though wrong) and texts.
I used "text-to-comlumns" (on the Data ribbon) to fix this so that a custom format can be applied as desired. See attached, and check if this is indeed what you want/need.