I have a import macro that imports a lot of data and I import a date and time from one excel sheet that has a wrong format.
format it starts as
2022:02:01:01:51:53
what I use to import
format I want it in after importSurveys.Range("A17:A" & maxRow + 14) = wBookSvy.Range("A3:A" & maxRow).Value
2/1/2022 1:51:53 AM
is this possible.
IK tried changing the cell format but could get it correct
Bookmarks