[Elizabeth, Sonoma County]

When I am merging formatted dates (=date in another cell plus 14 days) the
merged results are the numerical equivalents of the dates. How can I keep the
actual formatted dates without saving the dates in the spreadsheet as values?
Other typical merging errors include losing the number formatting (dollar
signs, comma separator, etc.)

[Peter Jamieson]

Have a look at

http://tips.pjmsn.me.uk/t0003.htm

The DDE method may work for you.
--
Peter Jamieson
http://tips.pjmsn.me.uk

"Elizabeth, Sonoma County" Elizabeth, Sonoma
wrote in message
...
When I am merging formatted dates (=date in another cell plus 14 days) the
merged results are the numerical equivalents of the dates. How can I keep
the
actual formatted dates without saving the dates in the spreadsheet as
values?
Other typical merging errors include losing the number formatting (dollar
signs, comma separator, etc.)

[macropod[_2_]]

Hi Elizabeth,

If you're wanting to add 14 days to the date in your mailmerge datasource, check out my Date Calc 'tutorial', at:
http://www.wopr.com/cgi-bin/w3t/show...?Number=249902
or
http://www.gmayor.com/downloads.htm#Third_party
In particular, look at the item titled 'Date and Time Calculations In A Mailmerge'. Do read the document's introductory material.

For number formatting in general, see: http://www.gmayor.com/formatting_word_fields.htm


--
Cheers
macropod
[MVP - Microsoft Word]


"Elizabeth, Sonoma County" Elizabeth, Sonoma wrote in message
...
When I am merging formatted dates (=date in another cell plus 14 days) the
merged results are the numerical equivalents of the dates. How can I keep the
actual formatted dates without saving the dates in the spreadsheet as values?
Other typical merging errors include losing the number formatting (dollar
signs, comma separator, etc.)