[Peter Jamieson]

Carol Marie,

Glad you got it working and thanks for letting us know.

--
Peter Jamieson
http://tips.pjmsn.me.uk

"CarolMarie" wrote in message
...
Thanks for your response. I tried yours and Doug's suggestion, but
seemed
to be chasing down a rabbit hole. I undid it, went back and finally
entered
a new column in my spreadsheet, renamed the previous one, placing the
column
name I wanted on the new column. That may have been superstitious
behavior
(unnecessary, unproductive), because at one point I needed to fix the
field
name to acknowledge the space with an underscore. With enough monkeying
around, reading, double checking I had slash vs backslash (or visa versa),
etc. I've finally got it working.

I appreciate your assistance,

Carol Marie

"Peter Jamieson" wrote:

The solution Doug suggested should work - if you want an "explanation"
there
is one at http://tips.pjmsn.me.uk/t0003.htm

--
Peter Jamieson
http://tips.pjmsn.me.uk

"CarolMarie" wrote in message
...
I even went to the letter I had that formats correctly, made a copy of
it,
replaced the text around the field I'm interested in, and connected to
my
data source (same excel file, different data set in another worksheet,
same
columns, same formatting from what I can tell) and I have the problem
in
the
new Word document.

If I point to the other worksheet, the date format is just what I want.

Any thoughts?

Carol Marie