How to Replace Slashes with Dots in Word Dates
Question details
The user needs to reformat date strings in a document by changing the separator from forward slashes to dots.

- Product
- Microsoft Word
- Device & OS
- not provided
- Scenario
- Standardizing date formatting across a large document to ensure all dates use dots instead of slashes.
- Observed behavior
- Dates are currently formatted with slashes (e.g., 01/15/2024) and need to be uniformly updated to use dots (e.g., 01.15.2024) without manually editing each entry.
Before making batch replacements using wildcards, save a copy of your document to prevent accidental data loss in case the parameters modify unintended text.
Use Wildcard Find and Replace
Utilize Word's advanced Find and Replace feature with wildcards to accurately target numerical date formats and replace the separators.
Word's wildcard feature allows you to define complex patterns for searching. By breaking the date into three specific numerical groups (month, day, year), you can keep the numbers intact while only changing the slash separators to dots.
Press Ctrl + H on your keyboard to open the Find and Replace dialog box.
Click on the 'More' button to expand the search options and check the 'Use wildcards' box.
In the 'Find what' field, enter exactly: ([0-9]{1,2})/([0-9]{1,2})/([0-9]{2,4})
In the 'Replace with' field, enter exactly: \1.\2.\3
Click 'Find Next' to verify it selects a date correctly, then click 'Replace' or 'Replace All' to update the document.

Easily Format Text and Dates with WPS Office
WPS Office offers a powerful, free Word alternative with comprehensive Find and Replace capabilities. You can seamlessly use wildcards to reformat dates, clean up text, and manage complex document editing just like you do in Microsoft Word.
- 1. Open WPS Writer: Launch WPS Writer and open your document containing the dates.
- 2. Access Find and Replace: Press Ctrl+H to open the Find and Replace dialog and check the 'Use wildcards' option.
- 3. Execute Replacement: Input the wildcard strings for the dates, insert the dot separators in the replacement box, and click Replace All.

Frequently Asked Questions
Why did 'Replace All' change non-date text in my document?
If your wildcard parameters are too broad, they might capture other number combinations separated by slashes, like fractions or reference codes. It is highly recommended to click 'Find Next' and 'Replace' a few times to ensure the pattern is only catching actual dates before hitting 'Replace All'.
Can I change dots back to slashes using the same method?
Yes. You would use ([0-9]{1,2}).([0-9]{1,2}).([0-9]{2,4}) in the 'Find what' field (you may need a backslash before the dot to escape it, i.e., \.) and \1/\2/\3 in the 'Replace with' field.
What does [0-9]{1,2} mean in the search field?
This is a wildcard instruction telling the program to look for any digit from 0 to 9, and to specifically look for groupings of 1 to 2 digits in length. This matches months (1 to 12) and days (1 to 31) without capturing overly long numbers.




