Hi all, I have a download which stores dates in the format as follows 04.01.2017.
To convert them to an actual date I use a piece of code below
However, when I do this, it stores the date as 01/04/2017. I am sure this is an easy fix / add in to the code that has been asked before but I can't find the solution.
Please Login or Register to view this content.
Can someone assist please?
TIA
What format are you using in the date column? United Kingdon or United States?
Teach me Excel VBA
I think your code is ok. Just change the date format of the date column as *3/14/2012 with United States location
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks