Forum Discussion
Solved
VBA to synchronize date formats.
Hello, Here is the problem. I need to sync dates in D column (they should be in one format, preferably dd.MM.yyy). Is there any VBA script to do it? Please find the file attached. Kind regar...
You may select column D, Data->Text to Columns, on 3rd step Date and MDY. After that Ctrl+1 and apply desired date format.
You may select column D, Data->Text to Columns, on 3rd step Date and MDY. After that Ctrl+1 and apply desired date format.
- Hello @Sergei Balkan,
Thank you for your help! Seems working. I guess if I macro record these steps I will get VBA code.
Kind regards,
Guram