Document Editing Problems

How to Change Text Dates from dd/mm/yyyy to dd MMM yyyy in Word

John Wilson Oct 9, 2026 869 views

Question details

The user needs to find plain text dates formatted as dd/mm/yyyy in a Word document and safely convert them to dd MMM yyyy format without altering non-date text.

How to Change Text Dates from dd/mm/yyyy to dd MMM yyyy in Word

Product: Microsoft Word
Device & OS: not provided
Scenario: Reformatting text-based dates across a document uniformly without triggering regional date-setting misinterpretations (such as confusing US and UK date formats).
Observed behavior: Dates are currently stored as plain text in the dd/mm/yyyy format and need to be explicitly parsed and replaced with the dd MMM yyyy format (e.g., 01 Jan 2023).

Before you start

Before running any VBA macros, ensure you save a backup copy of your Word document to prevent accidental data loss during bulk text replacement.

Solution 1Recommended

Use a VBA Macro to Safely Parse and Convert Dates

This method uses a VBA macro with wildcards to explicitly split the day, month, and year, preventing Windows regional settings from misinterpreting the dates.

Using standard 'IsDate' or 'Format' functions can be risky because Word relies on your system's regional settings. A date like 8/4/2023 might be incorrectly read as August 4th instead of April 8th. Explicitly parsing the text string into distinct day, month, and year variables avoids this issue.

Open the VBA Editor

Press Alt + F11 in Microsoft Word to open the Visual Basic for Applications (VBA) Editor.

Create a New Module

Click on 'Insert' in the top menu and select 'Module' to create a blank script window.

Write the Wildcard Search

Set up your macro to search for the wildcard pattern [0-9]{1,2}/[0-9]{1,2}/[0-9]{4} to locate all standard date strings in the document.

Parse and Replace

Within the macro loop, split the matched text by the '/' character to extract the day, month, and year. Convert the numeric month into a three-character abbreviation (e.g., 'Jan', 'Feb') and output the new string.

Run the Macro

Press F5 to execute the macro. The script will safely replace all matching dd/mm/yyyy plain text dates with the new dd MMM yyyy format.

Use a VBA Macro to Safely Parse and Convert Dates

Wildcard Search Limitations: Ensure 'Use wildcards' is conceptually understood when modifying the macro, as standard text replacement will not recognize regex-like patterns.

Advanced Document Editing

Easily Manage Document Formatting with WPS Writer

WPS Office provides a highly compatible environment for editing Word documents, including powerful Find and Replace tools with wildcard support to make text manipulations quick and effortless.

1. Open your Document: Launch WPS Writer and open the document containing the dates you want to format.
2. Access Find and Replace: Press Ctrl + H to bring up the Find and Replace dialog box.
3. Enable Wildcards: Click the 'More' button to expand the options, then check the 'Use wildcards' box to allow advanced pattern matching.

Fully compatible with Microsoft Word formats (.docx, .doc).Built-in advanced Find and Replace with comprehensive wildcard support.Lightweight and completely free for basic document editing tasks.Familiar user interface allowing for a seamless transition from Microsoft Office.

microsoft office alternative - wps office

Frequently Asked Questions

Why do some dates change incorrectly when using the IsDate function?

The IsDate function relies on your computer's Windows regional settings. If your system uses a US date format (mm/dd/yyyy), it may misinterpret a UK date (dd/mm/yyyy), accidentally swapping the month and the day.

Can I use standard Find and Replace to change date formats in Word?

Standard Find and Replace cannot dynamically calculate month names from numbers. You must use wildcard searches combined with a VBA macro to parse the numbers and output the corresponding English month abbreviation.

What does the wildcard [0-9]{1,2}/[0-9]{1,2}/[0-9]{4} mean?

This wildcard pattern searches for 1 or 2 digits (day), followed by a slash, 1 or 2 digits (month), another slash, and exactly 4 digits (year). It effectively isolates standard date strings from regular text in your document.

Document & File Issues