Can some one please help me to understand, how to change the date format from excel.
Row values contains as below
In a cell it is 1/27/2020 0:00
But in formula bar 1/27/2020 12:00:00 AM
Confused which one to consider?
how to convert the above format to “dd/MM/yyyy”
Thank you so much for your kind help in advance.