SOLVED

VBA to synchronize date formats.

%3CLINGO-SUB%20id%3D%22lingo-sub-3289839%22%20slang%3D%22en-US%22%3EVBA%20to%20synchronize%20date%20formats.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3289839%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere%20is%20the%20problem.%20I%20need%20to%20sync%20dates%20in%20D%20column%20(they%20should%20be%20in%20one%20format%2C%20preferably%20dd.MM.yyy).%20Is%20there%20any%20VBA%20script%20to%20do%20it%3F%20Please%20find%20the%20file%20attached.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EKind%20regards%2C%3C%2FP%3E%3CP%3EGuram%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3289839%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3290924%22%20slang%3D%22en-US%22%3ERe%3A%20VBA%20to%20synchronize%20date%20formats.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3290924%22%20slang%3D%22en-US%22%3EHello%20%40Sergei%20Balkan%2C%3CBR%20%2F%3E%3CBR%20%2F%3EThank%20you%20for%20your%20help!%20Seems%20working.%20I%20guess%20if%20I%20macro%20record%20these%20steps%20I%20will%20get%20VBA%20code.%3CBR%20%2F%3E%3CBR%20%2F%3EKind%20regards%2C%3CBR%20%2F%3EGuram%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3290032%22%20slang%3D%22en-US%22%3ERe%3A%20VBA%20to%20synchronize%20date%20formats.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3290032%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1365133%22%20target%3D%22_blank%22%3E%40Guram_Bregadze%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20may%20select%20column%20D%2C%20Data-%26gt%3BText%20to%20Columns%2C%20on%203rd%20step%20Date%20and%20MDY.%20After%20that%20Ctrl%2B1%20and%20apply%20desired%20date%20format.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3289926%22%20slang%3D%22en-US%22%3ERe%3A%20VBA%20to%20synchronize%20date%20formats.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3289926%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1225189%22%20target%3D%22_blank%22%3E%40Doug_Robbins_Word_MVP%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20mean%20make%20them%20all%20be%20dd.MM.yyyy%20style.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3289902%22%20slang%3D%22en-US%22%3ERe%3A%20VBA%20to%20synchronize%20date%20formats.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3289902%22%20slang%3D%22en-US%22%3EWhat%20do%20you%20mean%20by%20%22sync%20dates%22%3F%3C%2FLINGO-BODY%3E
Occasional Contributor

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

4 Replies
What do you mean by "sync dates"?

Hello, @Doug_Robbins_Word_MVP

 

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

best response confirmed by Guram_Bregadze (Occasional Contributor)
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.

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