Transpose dates from mm/dd/yy to yy/mm/dd


Transpose dates from mm/dd/yy to yy/mm/dd

Example: from 12/17/85 to 85/12/17

Article contributed by Bill Coan

Use Word's wildcard Find & Replace capabilities.

1.	Click More... in the Replace dialog box and check Use Wildcards.
2.	Enter the following values into the dialog: Find What: ([0-9]{1,2})/([0-9]{1,2})/([0-9]{1,2}) Replace With: \3/\1/\2
3.	Place an X in the “Use Wildcards” box.
4.	Click Replace All.

For many more examples of wildcard searches, including more date examples; and for in-depth coverage of how to use wildcards, see: Finding and replacing characters using wildcards.