View Single Post
 
Old 09-18-2019, 03:23 AM
jammyemma jammyemma is offline Windows 10 Office 2013
Novice
 
Join Date: Sep 2019
Posts: 2
jammyemma is on a distinguished road
Default Macro for changing date format from US to European

Hello, I'm hoping you can help me. I'm working on an enormous document which is full of dates formatted in the US style, as in 'July 12, 2016'. I want to change all of these to the UK style '12 July 2016'.
I've been using a find and replace I found on another forum (find (January) ([0-9]{1,2}),, and replace with \2 \1 but it gives a spacing error which I then have to correct. I also have to do each month separately which is a bit of a faff. So I was wondering if anyone knew of a macro which could do this for me?
All help gratefully received!
Thank you.

Last edited by Charles Kenyon; 09-23-2019 at 09:13 AM. Reason: Mark as solved
Reply With Quote