etaf
In my file I have many rows in Col A with date and Time format. I want to convert to date in Col C.
In my file [Nov 2, 2019 8:10:20 AM] was in A2.
I used [=MID(A2,1,12)] in B2 and got [Nov 2, 2019] in B2.
As per your suggestion I used [=VALUE(RIGHT(B2, 16))[ and got [43776] in C2.
I did format C2 as [DATE] and chose [14-Mar-2001] [Eng (US)] and got [2-Nov-2019].
A. Am I doing right or should I do something else to make it easier?
B. Kindly suggest me how to use in vba.
In my file I have many rows in Col A with date and Time format. I want to convert to date in Col C.
In my file [Nov 2, 2019 8:10:20 AM] was in A2.
I used [=MID(A2,1,12)] in B2 and got [Nov 2, 2019] in B2.
As per your suggestion I used [=VALUE(RIGHT(B2, 16))[ and got [43776] in C2.
I did format C2 as [DATE] and chose [14-Mar-2001] [Eng (US)] and got [2-Nov-2019].
A. Am I doing right or should I do something else to make it easier?
B. Kindly suggest me how to use in vba.