Formatting Issues

How to Preserve Excel Date Formats in Word with Power Automate

Algirdas JasaitisAlgirdas Jasaitis Nov 4, 2026 869 views

Question details

The user needs to maintain the mm/dd/yyyy date format when transferring data from an Excel spreadsheet to a Word document using Power Automate.

How to Preserve Excel Date Formats in Word Using Power Automate
Product
Microsoft Excel, Microsoft Word, Power Automate
Device & OS
not provided
Scenario
Automating data transfer from an Excel spreadsheet to a Word document template using a Power Automate flow.
Observed behavior
Dates formatted as mm/dd/yyyy in Excel are appearing in a different format (such as yyyy-mm-dd) or as raw serial numbers in the generated Word document.
Before you start

Verify whether your Word document template uses Content Controls, MergeFields, or DocVariables, as the correct date formatting solution will depend on the specific field type.

Solution 1Recommended

Use the formatDateTime Function in Power Automate

Convert the raw Excel date value into the desired format directly within your Power Automate flow before inserting it into Word.

Because Excel stores dates internally as serial numbers, Power Automate retrieves the raw value rather than the displayed format. You can reformat this data within the flow before it is passed to the Word template.

1
Locate the Word step

Open your Power Automate flow and locate the action step where the Excel date is being populated into the Word document.

2
Access the Expression builder

Click on the input field for the date to open the dynamic content menu, then switch to the 'Expression' tab.

3
Enter the formatting function

Type the expression formatDateTime(item()?['YourDateColumnName'], 'MM/dd/yyyy'), making sure to replace 'YourDateColumnName' with your actual column's name.

4
Save and test

Click 'OK' to insert the expression, then save and run a test of your flow to verify the date appears correctly in the generated Word document.

Use the formatDateTime Function in Power Automate
Expression syntax: Ensure that 'MM' is capitalized in your format string so it represents months rather than minutes.
Free Microsoft Office alternative

Experience Seamless Document and Spreadsheet Formatting with WPS Office

If you frequently encounter complex formatting issues between word processors and spreadsheets, consider trying WPS Office. It provides robust, built-in Mail Merge features that make transferring data from spreadsheets to text documents straightforward, free, and highly compatible with Microsoft file formats.

Fully compatible with Microsoft Excel (.xlsx) and Word (.docx) file formats.Intuitive Mail Merge function that preserves spreadsheet formatting effortlessly.Lightweight application with a familiar, easy-to-navigate tabbed user interface.Free to download and use for all your essential daily office tasks.
microsoft office alternative - wps office

Frequently Asked Questions

Why do Excel dates appear as numbers when transferred to Word?

Excel stores dates internally as serial numbers (e.g., 44000) rather than text. When data is transferred to Word without a specific formatting rule, Power Automate passes the raw serial number instead of the visual format applied in your Excel spreadsheet.

Can I format dates directly in Excel before using Power Automate?

Yes. You can convert the date to a text string directly in Excel using the TEXT function (e.g., =TEXT(A2, "mm/dd/yyyy")). Power Automate will then read it as standard text and pass it exactly as it appears into your Word document.

What are some common date formatting switches I can use in Word?

Common formatting switches include \@ "MM/dd/yyyy" for standard US dates, \@ "dd MMMM yyyy" for formats like '01 January 2023', and \@ "MMM-yy" for short formats like 'Jan-23'.