How keep date format from excel to merged list

[Guest]

Date format changes from eg 27 Feb 06 to 2/27/2006 when I merge from excel to
a list in a table. How keep my preferred format?

 

[Peo Sjoblom]

using word's mailmerge you need to change that in word

http://office.microsoft.com/en-ca/assistance/HA011164951033.aspx#field codes

or use text dates in Excel

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon

 

[Guest]

Peo: I've tried all the optionsin excel cell forms: text, general, etc. None
allow me to keep my dates as text. Every one converts. Please help me w other
options.

 

[Peo Sjoblom]

Use the word options in the link

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon

 

[Guest]

Peo: Thanks for sticking w me. -- How do I use the word options in the link?
I've looked everywhere I can think of when I'm doing the mailmerge from excel
into my list.
Cyrus

 

[Peo Sjoblom]

Here are some links

http://www.mvps.org/dmcritchie/excel/mailmerg.htm

http://word.mvps.org/FAQs/MailMerge/CreateADataSource.htm

http://word.mvps.org/FAQs/MailMerge/CreateAMailMerge.htm

http://word.mvps.org/FAQs/MailMerge/

in the last link there is another link called

How to force Word to use the number format you want in a mail merge field

I think that is what you are looking for


btw, you use Alt + F9 to show the field codes


I have no problems if I use text dates, not just formatted as text but real
text either by using

=TEXT(Date_cell,"mm/dd/yy")

or formatting cell as text

Also in a case like this you are probably better off asking in the Word
mailmerge newsgroup