In Word, the format of any field that outputs a date is controlled by formatting switches. In Excel, it's controlled by cell formats. Either application can display a date in whatever format you want; you just have to do it the way the application requires.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
|