markster
Well-known Member
- Joined
- May 23, 2002
- Messages
- 579
- Office Version
- 365
- Platform
- Windows
- MacOS
Hey folks
I'm after a bit of macro code that will solve a problem. I have a spreadsheet with thousands of transactions. The date and time of the transaction is in Column B (B7 to B65000). The date and time format is as follows 2020.11.24 02:52:51. I'm only interested in the date of the transaction and not the time. I'm after some macro code that will look down column B and change the date format to DD-MMM-YY and remove the time of the transaction. So in the example I've given it will just be changed to 24-NOV-20. Can Anyone help?
Thanks in advance
Mark
I'm after a bit of macro code that will solve a problem. I have a spreadsheet with thousands of transactions. The date and time of the transaction is in Column B (B7 to B65000). The date and time format is as follows 2020.11.24 02:52:51. I'm only interested in the date of the transaction and not the time. I'm after some macro code that will look down column B and change the date format to DD-MMM-YY and remove the time of the transaction. So in the example I've given it will just be changed to 24-NOV-20. Can Anyone help?
Thanks in advance
Mark