How to Preserve Excel Date Formats in Word with Power Automate
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.

- 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.
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.
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.
Open your Power Automate flow and locate the action step where the Excel date is being populated into the Word document.
Click on the input field for the date to open the dynamic content menu, then switch to the 'Expression' tab.
Type the expression formatDateTime(item()?['YourDateColumnName'], 'MM/dd/yyyy'), making sure to replace 'YourDateColumnName' with your actual column's name.
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.

Apply a Date Formatting Switch in Microsoft Word
Modify the field code directly in your Word template to force the incoming date into a specific format.
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.

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'.




