vbacoder
Active Member
- Joined
- Jul 7, 2007
- Messages
- 354
Hi everyone,
I have some data that contains a mixture of UK and US-style date formats. The data is quite vast so selecting one or other type manually to convert manually is not feasible. Is there an automatic way to convert the column of data to one of the two formats?
Many thanks!
I have some data that contains a mixture of UK and US-style date formats. The data is quite vast so selecting one or other type manually to convert manually is not feasible. Is there an automatic way to convert the column of data to one of the two formats?
Many thanks!