Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel Dates formatting in Word
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? -- Paul |
#2
|
|||
|
|||
Hi ?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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
The WordPerfect "Reveal Codes" method is so much easier to use. | Microsoft Word Help | |||
is word perfect compatible with office word? | Microsoft Word Help | |||
Making Word do something that Wordperfect can do | New Users | |||
In Word, how can I see all files (*.*) in "save as"? | New Users | |||
Wordperfect Office 2000 conversion to Word 2003 | New Users |