Date Format Frustration - inconsistency

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

Yes, all 3 are formatted exactly the same.

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

 

[Graham Mayor]

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

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

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