Wd '03-Date formats from Excel changed

[RWN]

Converted a Mail Merge template from '97.
Source file is an Excel WkBk (one sheet).
The workbook is on a network drive.
Dates on the XL records are formatted as yy-mm-dd
The merge insists on changing then to mm-dd-yy.
How can I "carve the format in stone"?

Also, why does the (annoying safety feature) tell me the source file is from "ICP$"
whenever I change the source?

This used to be so simple!

Regards;
Rob
-------------------------------------------------

 

[Doug Robbins]

See the "Dates: day/month reversed" item under the "Connection methods"
topic of the "Mail merge in Word 2002" section of fellow MVP Cindy
Meister's website at
http://homepage.swissonline.ch/cindymeister/MergFram.htm


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

 

[RWN]

Excellent.
(And at least I know it's not me!)
Thanks.
--
Regards;
Rob
------------------------------------------------------------------------

See the "Dates: day/month reversed" item under the "Connection methods"
topic of the "Mail merge in Word 2002" section of fellow MVP Cindy
Meister's website at
http://homepage.swissonline.ch/cindymeister/MergFram.htm


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