GeorgeVince
06-15-2017, 03:03 PM
Hey,
I have a dataset of UK dates (DD/MM/YYYY), I've imported them and and converted them to (MM/DD/YYYY) using Range.NumberFormat = MM/DD/YYYY
When I open the dataset on my PC (UK), I see the dates in the MM/DD/YYYY format working as intended...
When I send the data to my client he still sees the dates as DD/MM/YYYY.
How can I bulk changes the dates from DD/MM/YYYY -> MM/DD/YYYY. I'm sure it's something simple but I just can't work it out!!:banghead:
The only other option I can think of is changing looping through all dates and changing the using a split function:
Split(oTxt, "/")(1) & "/" & Split(oTxt, "/")(0) & "/" & Split(oTxt, "/")(2)
I have over 300 files, with 400k dates in each file. Surely there's a quicker way to do this??
I have a dataset of UK dates (DD/MM/YYYY), I've imported them and and converted them to (MM/DD/YYYY) using Range.NumberFormat = MM/DD/YYYY
When I open the dataset on my PC (UK), I see the dates in the MM/DD/YYYY format working as intended...
When I send the data to my client he still sees the dates as DD/MM/YYYY.
How can I bulk changes the dates from DD/MM/YYYY -> MM/DD/YYYY. I'm sure it's something simple but I just can't work it out!!:banghead:
The only other option I can think of is changing looping through all dates and changing the using a split function:
Split(oTxt, "/")(1) & "/" & Split(oTxt, "/")(0) & "/" & Split(oTxt, "/")(2)
I have over 300 files, with 400k dates in each file. Surely there's a quicker way to do this??