#1
|
|||
|
|||
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 |
#2
|
||||
|
||||
You don't need a macro for this - it can be done via a single wildcard Find/Replace, where:
Find = (<[JFMASOND][abceghilmnoprstuvy]{2,8} )([0-9]{1,2}), ([12][0-9]{3}>) Replace = \2 \1\3 You could, of course, turn the above into a wildcard Find/Replace macro.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
Brilliant, thanks so much. That works perfectly and is going to make my working life so much easier. Thanks again!
|
Tags |
dates in word |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Changing date Format | Borut2019 | Excel | 1 | 02-18-2019 01:46 AM |
Changing Date/time to Australia format | tmeck63 | Project | 1 | 01-07-2016 09:11 PM |
Help needed in changing date format | Rose roon | Excel | 5 | 07-27-2015 11:57 PM |
Document opening with unreadable characters - converter says W. European | Ed354 | Word | 1 | 07-03-2014 12:29 AM |
changing date format in Bibliography field | elly111sk | Word | 3 | 07-25-2012 06:54 PM |