wilcowoods
Active Member
- Joined
- May 29, 2008
- Messages
- 275
Hi guys - tricky one I think.
I'm using 2007 / 2010 Excel to convert multiple columns from date to text format in VBA whilst retaining the dd/mm/yyyy format.
If I use Text To Columns manually and just select text at the end (without parsing any data), it works fine. If I code this, it then converts the dates to text but in the US date order (so mm/dd/yyyy).
Any ideas about how to navigate around this?
Any advice gratefully accepted.
Regards
Will
I'm using 2007 / 2010 Excel to convert multiple columns from date to text format in VBA whilst retaining the dd/mm/yyyy format.
If I use Text To Columns manually and just select text at the end (without parsing any data), it works fine. If I code this, it then converts the dates to text but in the US date order (so mm/dd/yyyy).
Any ideas about how to navigate around this?
Any advice gratefully accepted.
Regards
Will