software

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?

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

office.microsoft.com/en-ca/as...#field codes

or use text dates in Excel

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon

quot;Cyrusquot; gt; wrote in message
...
gt; Date format changes from eg 27 Feb 06 to 2/27/2006 when I merge from excel
gt; to
gt; a list in a table. How keep my preferred format?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.

quot;Peo Sjoblomquot; wrote:

gt; using word's mailmerge you need to change that in word
gt;
gt; office.microsoft.com/en-ca/as...#field codes
gt;
gt; or use text dates in Excel
gt;
gt; --
gt;
gt; Regards,
gt;
gt; Peo Sjoblom
gt;
gt; Northwest Excel Solutions
gt;
gt; www.nwexcelsolutions.com
gt;
gt; (remove ^^ from email address)
gt;
gt; Portland, Oregon
gt;
gt;
gt;
gt;
gt; quot;Cyrusquot; gt; wrote in message
gt; ...
gt; gt; Date format changes from eg 27 Feb 06 to 2/27/2006 when I merge from excel
gt; gt; to
gt; gt; a list in a table. How keep my preferred format?
gt;
gt;

Use the word options in the link

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon

quot;Cyrusquot; gt; wrote in message
...
gt; Peo: I've tried all the optionsin excel cell forms: text, general, etc.
gt; None
gt; allow me to keep my dates as text. Every one converts. Please help me w
gt; other
gt; options.
gt;
gt; quot;Peo Sjoblomquot; wrote:
gt;
gt;gt; using word's mailmerge you need to change that in word
gt;gt;
gt;gt; office.microsoft.com/en-ca/as...#field codes
gt;gt;
gt;gt; or use text dates in Excel
gt;gt;
gt;gt; --
gt;gt;
gt;gt; Regards,
gt;gt;
gt;gt; Peo Sjoblom
gt;gt;
gt;gt; Northwest Excel Solutions
gt;gt;
gt;gt; www.nwexcelsolutions.com
gt;gt;
gt;gt; (remove ^^ from email address)
gt;gt;
gt;gt; Portland, Oregon
gt;gt;
gt;gt;
gt;gt;
gt;gt;
gt;gt; quot;Cyrusquot; gt; wrote in message
gt;gt; ...
gt;gt; gt; Date format changes from eg 27 Feb 06 to 2/27/2006 when I merge from
gt;gt; gt; excel
gt;gt; gt; to
gt;gt; gt; a list in a table. How keep my preferred format?
gt;gt;
gt;gt;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

quot;Peo Sjoblomquot; wrote:

gt; Use the word options in the link
gt;
gt; --
gt;
gt; Regards,
gt;
gt; Peo Sjoblom
gt;
gt; Northwest Excel Solutions
gt;
gt; www.nwexcelsolutions.com
gt;
gt; (remove ^^ from email address)
gt;
gt; Portland, Oregon
gt;
gt;
gt;
gt;
gt; quot;Cyrusquot; gt; wrote in message
gt; ...
gt; gt; Peo: I've tried all the optionsin excel cell forms: text, general, etc.
gt; gt; None
gt; gt; allow me to keep my dates as text. Every one converts. Please help me w
gt; gt; other
gt; gt; options.
gt; gt;
gt; gt; quot;Peo Sjoblomquot; wrote:
gt; gt;
gt; gt;gt; using word's mailmerge you need to change that in word
gt; gt;gt;
gt; gt;gt; office.microsoft.com/en-ca/as...#field codes
gt; gt;gt;
gt; gt;gt; or use text dates in Excel
gt; gt;gt;
gt; gt;gt; --
gt; gt;gt;
gt; gt;gt; Regards,
gt; gt;gt;
gt; gt;gt; Peo Sjoblom
gt; gt;gt;
gt; gt;gt; Northwest Excel Solutions
gt; gt;gt;
gt; gt;gt; www.nwexcelsolutions.com
gt; gt;gt;
gt; gt;gt; (remove ^^ from email address)
gt; gt;gt;
gt; gt;gt; Portland, Oregon
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt; gt;gt; quot;Cyrusquot; gt; wrote in message
gt; gt;gt; ...
gt; gt;gt; gt; Date format changes from eg 27 Feb 06 to 2/27/2006 when I merge from
gt; gt;gt; gt; excel
gt; gt;gt; gt; to
gt; gt;gt; gt; a list in a table. How keep my preferred format?
gt; gt;gt;
gt; gt;gt;
gt;
gt;

Here are some links

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

word.mvps.org/FAQs/MailMerge/...DataSource.htm

word.mvps.org/FAQs/MailMerge/...AMailMerge.htm

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 forbtw, you use Alt F9 to show the field codesI have no problems if I use text dates, not just formatted as text but real
text either by using

=TEXT(Date_cell,quot;mm/dd/yyquot;)

or formatting cell as text

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

Regards,

Peo Sjoblomquot;Cyrusquot; gt; wrote in message
...
gt; Peo: Thanks for sticking w me. -- How do I use the word options in the
gt; link?
gt; I've looked everywhere I can think of when I'm doing the mailmerge from
gt; excel
gt; into my list.
gt; Cyrus
gt;
gt; quot;Peo Sjoblomquot; wrote:
gt;
gt;gt; Use the word options in the link
gt;gt;
gt;gt; --
gt;gt;
gt;gt; Regards,
gt;gt;
gt;gt; Peo Sjoblom
gt;gt;
gt;gt; Northwest Excel Solutions
gt;gt;
gt;gt; www.nwexcelsolutions.com
gt;gt;
gt;gt; (remove ^^ from email address)
gt;gt;
gt;gt; Portland, Oregon
gt;gt;
gt;gt;
gt;gt;
gt;gt;
gt;gt; quot;Cyrusquot; gt; wrote in message
gt;gt; ...
gt;gt; gt; Peo: I've tried all the optionsin excel cell forms: text, general, etc.
gt;gt; gt; None
gt;gt; gt; allow me to keep my dates as text. Every one converts. Please help me w
gt;gt; gt; other
gt;gt; gt; options.
gt;gt; gt;
gt;gt; gt; quot;Peo Sjoblomquot; wrote:
gt;gt; gt;
gt;gt; gt;gt; using word's mailmerge you need to change that in word
gt;gt; gt;gt;
gt;gt; gt;gt; office.microsoft.com/en-ca/as...#field codes
gt;gt; gt;gt;
gt;gt; gt;gt; or use text dates in Excel
gt;gt; gt;gt;
gt;gt; gt;gt; --
gt;gt; gt;gt;
gt;gt; gt;gt; Regards,
gt;gt; gt;gt;
gt;gt; gt;gt; Peo Sjoblom
gt;gt; gt;gt;
gt;gt; gt;gt; Northwest Excel Solutions
gt;gt; gt;gt;
gt;gt; gt;gt; www.nwexcelsolutions.com
gt;gt; gt;gt;
gt;gt; gt;gt; (remove ^^ from email address)
gt;gt; gt;gt;
gt;gt; gt;gt; Portland, Oregon
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt; gt;gt; quot;Cyrusquot; gt; wrote in message
gt;gt; gt;gt; ...
gt;gt; gt;gt; gt; Date format changes from eg 27 Feb 06 to 2/27/2006 when I merge from
gt;gt; gt;gt; gt; excel
gt;gt; gt;gt; gt; to
gt;gt; gt;gt; gt; a list in a table. How keep my preferred format?
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt;
gt;gt;