Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17


Excel mailmerge to Word changing TEXT to DATE format

Posted on 2006-11-29
Medium Priority
Last Modified: 2010-05-18
Greetings all,

I have an excel file that I am using as the data source for a mail merge document.  One column is labeled SiteSurvey and it contains a date formatted as TEXT which has data such “11-15 September 2006”  “29 Oct – 4 Nov 2006” and so on.

When I add this field to the word document it only displays as 12:00:00 AM.  I gather that either word or excel is seeing this as a formula date field rather than a text field and is trying to convert it.  I don’t want it to convert anything I just want the straight text ported over.  Considering that it's formatted as TEXT in Excel I suspect Word is the culprit.

I’ve looked through the other solutions here relating to Excel/Word date problems and don’t see anything that relates.  I am using Office 2003/SP2 and everything has been updated/patched/hotfixed appropriately.  

Any help, advice, or ideas would be welcome. I have 130 of these documents to merge/create by yesterday so I'm a little pressed for time - thus the 500 points offered.


Question by:mullinsbc
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
LVL 14

Expert Comment

ID: 18038056

Author Comment

ID: 18038720
Thanks Glenn.  I had seen that earlier in my search but it wasn't helpful.

I just found the answer though and came here to post what I found.

The fix was under the "Use Dynamic Data Exchange."  Its a bit clunky because I now have to confirm a data conversion everytime I want to use that excel file, but at least it works.

LVL 76

Expert Comment

ID: 18038779
I can  only reproduce that problem if the field is unnecessarily formatted with a date switch, like

{ MERGEFIELD "daterange" \@ "hh:mm:ss" }

(Field code display can be toggeled on and off weith Alt + F9)
New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.


Author Comment

ID: 18041827
Mine was only { MERGEFIELD "SiteSurvey" } with nothing else.
LVL 76

Expert Comment

ID: 18041873
Didn't see your penultimate post.

DDE was the old default and ODBC is the new default. DDE copies what you see, rather than the underlying values, though simple text should appear the same with either method.

You can ask for a points refund in the Support area.

Author Comment

ID: 18044756
True, text is text is text and it should port over with no problems.  I take some measure of comfort in knowing that I'm not the only one with the issue - Microsoft posted a work around for it so I reckon that the problem has been known for a while.  The down side is - Microsoft posted a work around for it so I reckon that the problem has been known for a while.  :-)


Accepted Solution

DarthMod earned 0 total points
ID: 18077446
PAQd, 500 points refunded.

CS Moderator

Featured Post

[Webinar] Lessons on Recovering from Petya

Skyport is working hard to help customers recover from recent attacks, like the Petya worm. This work has brought to light some important lessons. New malware attacks like this can take down your entire environment. Learn from others mistakes on how to prevent Petya like worms.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It is often necessary in this forum and others to illustrate Word fields as text with the field delimiters replaced with the curly brackets that the delimiters resemble when field codes are being displayed on the document. This means that the text c…
I'm writing to share my clumsy experience in using this elegant tool so you can avoid every stupid mistake I made. (I leave it to the authorities to decide if this deserves a place in the Knowledge archives.)  Now that I am on the other side of my l…
This video shows and describes the main difference between both orientations in Microsoft Word. Viewers will understand when to use each orientation and how to get the most out of them.
This video shows where to find the word count, how to display it, and what it breaks down to in Microsoft Word.

704 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question