I have date column(column T) in my excel as shown in below format
I want to change the whole column values into “dd/MM/yyyy” format…
May I know is there any shortcut to do it without looping each column?Because when I tried to change it in the Format cells option, the column values are not turning into the required format(“dd/MM/yyyy”).
Please suggest me some idea on to how to achieve this. @Palaniyappan
Thanks in advance!