Excel Dates formatting in Word

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Paul - NottsUK - 13 May 2005 14:20 GMT

I'm merging a number of dates from Excel 2003 into Word 2003 using

{MERGEFIELD "fieldnameX" \@"dd MMM yy"}

The first line of dates appear ok but subsequent lines revert to numeric
form 38442 for 31 Mar 05

Has anyone got any ideas what is going on?

Signature

Paul

Reply to this Message

Cindy M -WordMVP- - 22 May 2005 08:02 GMT

Hi =?Utf-8?B?UGF1bCAtIE5vdHRzVUs=?=,

> I'm merging a number of dates from Excel 2003 into Word 2003 using
>
> {MERGEFIELD "fieldnameX" \@"dd MMM yy"}
>
> The first line of dates appear ok but subsequent lines revert to numeric
> form 38442 for 31 Mar 05

Could be any number of things...

1. Do you see this if you create a new merge document (for testing) and
link the data source to it, recreate the field there?

2. If yes, then you need to check the Excel data. For some reason, the OLE
DB provider in combination with the Excel ODBC driver (the former links to
Excel through the latter) is not seeing the contents of this column as
dates, but as plain numbers. Check the formatting you've applied to that
column?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail :-)

Reply to this Message