VBA to synchronize date formats.

[Guram_Bregadze]

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

Guram

[#2]

What do you mean by "sync dates"?

[#3]

Hello, @Doug_Robbins_Word_MVP

I mean make them all be dd.MM.yyyy style. 

[#4 · Accepted solution]

@Guram_Bregadze 

You may select column D, Data->Text to Columns, on 3rd step Date and MDY. After that Ctrl+1 and apply desired date format.

[#5]

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