View Single Post
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Word Merge w/Excel Data

Have you tried the DDE method of connecting to the data source?


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com
"Smiley" wrote in message
...
My word document continues to change my cell information for the date. I
originally had i.e. 10/27/09 then changed it to October 27, 2009. I made
sure that the cell was a date format, then changed it to a text format,
and
resaved. But when I redid the merge it picked up the data as numerical
again.

I have also gone in and changed the "conversion" part under Tools &
General
tab. Still didn't work.

It is 3:30 pm & I am losing my mind. What simple step am I missing?