mikemcbain
Board Regular
- Joined
- Nov 14, 2005
- Messages
- 152
- Office Version
- 365
- Platform
- Windows
G;day Magicians
I have a problem that has thwarted me and ChatGPT for 4 hours today?
I am using Excel 365 and I have a csv file on my computer that has dates in Col A with a Header called DATE
I can copy and paste the contents of this file into an xlsm spreadsheet and the date format stays the same ie. 02/04/2013
However if I use a macro or VBA to copy paste or transfer the data the date comes out as 04/02/2023?
And then when I check back to the csv file it has also been changed to that format so I must create it all over again.
Can anyone offer suggestions about what is going on and how to overcome it?
We have tried text to columns, checked the Option settings and numerous other things.
With high hopes
Old Mike.
I have a problem that has thwarted me and ChatGPT for 4 hours today?
I am using Excel 365 and I have a csv file on my computer that has dates in Col A with a Header called DATE
I can copy and paste the contents of this file into an xlsm spreadsheet and the date format stays the same ie. 02/04/2013
However if I use a macro or VBA to copy paste or transfer the data the date comes out as 04/02/2023?
And then when I check back to the csv file it has also been changed to that format so I must create it all over again.
Can anyone offer suggestions about what is going on and how to overcome it?
We have tried text to columns, checked the Option settings and numerous other things.
With high hopes
Old Mike.