Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Suzanne Suzanne is offline
external usenet poster
 
Posts: 53
Default Very strange Excel to Word date conversion

I have an Excel spreadsheet with three columns of dates. All three columns
are formatted in Excel exactly the same way (10-Feb-2008)

The first and third column are showing up in the Word merge document AND in
the Mail Merge Recipients window as a serial date.

The second column is showing up in the Recipients window as a date, but not
in the right format (2/10/2008).

I set a switch code in the date fields to force the date format I need, but
(obviously) am having no luck. Help????

This one is showing up as "39488"
{MERGEFIELD "PROCESS_START_DATE" \@ "dd MMM yyyy" }

This one is showing up as "2/10/2008"
{MERGEFIELD "ACTUAL_SURVEY_DATE" \@ "dd MMM yyyy" }
 
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Word converts English date to USA date in mail-merge from Excel? DaveCujoPI Mailmerge 1 April 20th 07 03:04 PM
Strange behaviour of date fields in Excel-Word mailmerge Bill Bradley Mailmerge 2 September 8th 06 08:05 PM
Conversion of an Excel 200 document into Word 2000 designengineering Microsoft Word Help 2 August 23rd 05 04:41 AM
Word/Excel Conversion? maybe Microsoft Word Help 1 August 5th 05 04:30 PM
Date issue merging from Excel field in Date format to Word Barb Reinhardt Mailmerge 1 December 17th 04 07:34 AM


All times are GMT +1. The time now is 11:35 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"