[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.)