How do I merge formula results in Word 2007?

[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
(e-mail address removed)> wrote in message
news:[email protected]...

 

[macropod]

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/showthreaded.pl?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