[JimBob]

There are many postings over date format and I thought I'd got the measure of
it having referred to Graham Mayor's excellent site. Until . . .
I have a letter which populates with 3 dates from a client contact
spreadsheet. They were all formatting beautifully then bizarrely, after a
recent change elsewhere in the Word document, 2 format OK and 1 gives the
numerical value and I get, for instance: 23rd and 39715th. The field codes
are exactly the same, i.e. { MERGEFIELD "aDate1" \@ "d" \*Ordinal} and {
MERGEFIELD "aDate2" \@ "d" \*Ordinal}.
The 3rd date is elsewhere in the document and that's still fine. I've tried
replacing the mergefield and using it elsewhere in the document but that
gives the same result.

Any advice would be gratefully reecived. Many Thanks


I'm using Word 2003

[Doug Robbins - Word MVP]

Are the cells both formatted the same way in Excel?

--
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

"Jimbob" wrote in message
...
There are many postings over date format and I thought I'd got the measure
of
it having referred to Graham Mayor's excellent site. Until . . .
I have a letter which populates with 3 dates from a client contact
spreadsheet. They were all formatting beautifully then bizarrely, after a
recent change elsewhere in the Word document, 2 format OK and 1 gives the
numerical value and I get, for instance: 23rd and 39715th. The field
codes
are exactly the same, i.e. { MERGEFIELD "aDate1" \@ "d" \*Ordinal} and {
MERGEFIELD "aDate2" \@ "d" \*Ordinal}.
The 3rd date is elsewhere in the document and that's still fine. I've
tried
replacing the mergefield and using it elsewhere in the document but that
gives the same result.

Any advice would be gratefully reecived. Many Thanks


I'm using Word 2003

[JimBob]

Yes, all 3 are formatted exactly the same.


"Doug Robbins - Word MVP" wrote:

Are the cells both formatted the same way in Excel?

--
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

"Jimbob" wrote in message
...
There are many postings over date format and I thought I'd got the measure
of
it having referred to Graham Mayor's excellent site. Until . . .
I have a letter which populates with 3 dates from a client contact
spreadsheet. They were all formatting beautifully then bizarrely, after a
recent change elsewhere in the Word document, 2 format OK and 1 gives the
numerical value and I get, for instance: 23rd and 39715th. The field
codes
are exactly the same, i.e. { MERGEFIELD "aDate1" \@ "d" \*Ordinal} and {
MERGEFIELD "aDate2" \@ "d" \*Ordinal}.
The 3rd date is elsewhere in the document and that's still fine. I've
tried
replacing the mergefield and using it elsewhere in the document but that
gives the same result.

Any advice would be gratefully reecived. Many Thanks


I'm using Word 2003

[Graham Mayor]

What do {Mergefield aDate1} and {Mergefield aDate2} produce?

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



Jimbob wrote:
Yes, all 3 are formatted exactly the same.


"Doug Robbins - Word MVP" wrote:

Are the cells both formatted the same way in Excel?

--
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

"Jimbob" wrote in message
...
There are many postings over date format and I thought I'd got the
measure of
it having referred to Graham Mayor's excellent site. Until . . .
I have a letter which populates with 3 dates from a client contact
spreadsheet. They were all formatting beautifully then bizarrely,
after a recent change elsewhere in the Word document, 2 format OK
and 1 gives the numerical value and I get, for instance: 23rd and
39715th. The field codes
are exactly the same, i.e. { MERGEFIELD "aDate1" \@ "d" \*Ordinal}
and { MERGEFIELD "aDate2" \@ "d" \*Ordinal}.
The 3rd date is elsewhere in the document and that's still fine.
I've tried
replacing the mergefield and using it elsewhere in the document but
that gives the same result.

Any advice would be gratefully reecived. Many Thanks


I'm using Word 2003

[JimBob]

Well, you're not going to believe this but after spending an age on this
yesterday and this morning, I've opened it again and the Excel spreadsheet to
answer your question. I now find that all dates are exactly as I wanted and
expected them to be.
I'll surely be back with an answer to your question if the issue recurs.

Many thanks for your trouble.

"Graham Mayor" wrote:

What do {Mergefield aDate1} and {Mergefield aDate2} produce?

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



Jimbob wrote:
Yes, all 3 are formatted exactly the same.


"Doug Robbins - Word MVP" wrote:

Are the cells both formatted the same way in Excel?

--
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

"Jimbob" wrote in message
...
There are many postings over date format and I thought I'd got the
measure of
it having referred to Graham Mayor's excellent site. Until . . .
I have a letter which populates with 3 dates from a client contact
spreadsheet. They were all formatting beautifully then bizarrely,
after a recent change elsewhere in the Word document, 2 format OK
and 1 gives the numerical value and I get, for instance: 23rd and
39715th. The field codes
are exactly the same, i.e. { MERGEFIELD "aDate1" \@ "d" \*Ordinal}
and { MERGEFIELD "aDate2" \@ "d" \*Ordinal}.
The 3rd date is elsewhere in the document and that's still fine.
I've tried
replacing the mergefield and using it elsewhere in the document but
that gives the same result.

Any advice would be gratefully reecived. Many Thanks


I'm using Word 2003