[Smiley]

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?

[Doug Robbins - Word MVP]

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?