Forum Discussion

Copper Contributor

Apr 20, 2022

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

Guram

Original.xlsx45 KB

SergeiBaklan
Apr 20, 2022
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.
Original.xlsx47 KB

4 Replies

Doug_Robbins_Word_MVP
MVP
Apr 20, 2022
What do you mean by "sync dates"?
- Guram_Bregadze
  Copper Contributor
  Apr 20, 2022
  Hello, Doug_Robbins_Word_MVP
  
  I mean make them all be dd.MM.yyyy style.
  - SergeiBaklan
    Diamond Contributor
    Apr 20, 2022
    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.
    Original.xlsx47 KB

Resources