Excel mailmerge to Word changing TEXT to DATE format
Posted on 2006-11-29
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.