Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 09-18-2019, 03:59 PM
macropod's Avatar
macropod macropod is offline Macro for changing date format from US to European Windows 7 64bit Macro for changing date format from US to European Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,521
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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]
Reply With Quote
 

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
Macro for changing date format from US to European Changing Date/time to Australia format tmeck63 Project 1 01-07-2016 09:11 PM
Macro for changing date format from US to European Help needed in changing date format Rose roon Excel 5 07-27-2015 11:57 PM
Macro for changing date format from US to European Document opening with unreadable characters - converter says W. European Ed354 Word 1 07-03-2014 12:29 AM
Macro for changing date format from US to European changing date format in Bibliography field elly111sk Word 3 07-25-2012 06:54 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:20 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft