Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Jo4321 Jo4321 is offline
external usenet poster
 
Posts: 5
Default Entry of dates is changing when pulled into merged document

I have a word document that I am pulling info from an excel spreadsheet to
populate the form.

One of the columns in my spreadsheet is for the date I recieve a particular
piece of info from clients. Sometimes, the clients will send more than one
of thse pieces of info. When I recieve this info on more than one date, I've
been
putting a comma between the two dates.

Even though in my spreadsheet, the column looks like this "3/2/2009,
12/29/2009" (for the two dates I received the different info), when I pull
the data from this particular column into my word form, it changes the dates
to something like 12:00AM. I've tried changing the formatting of this column
in the spreadsheet to text and also to general; I've also tried putting an
apostrophe in front of the entry, but it still will not give me just the two
dates.

In short, I want the spreadsheet and the word document to treat this one
column as text and enter it exactly the way I have it...with the two dates
separated by the comma.

Any ideas?

 
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
CHANGING DATES in a DOCUMENT Pat Microsoft Word Help 2 August 22nd 09 06:32 AM
Single quotes changing to ?? in merged document Randy Bremgartner Microsoft Word Help 0 December 12th 07 05:36 PM
Changing name of document merged Janfry Mailmerge 3 July 11th 07 11:23 AM
Changing From field in a mail merged word document Larry Mailmerge 1 June 21st 07 06:33 PM
Can I link 2 dates in a document so changing 1 changes the other? alux999 Microsoft Word Help 1 February 4th 05 05:24 PM


All times are GMT +1. The time now is 09:49 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"