Excel date field link to Word
 

I have an excel spreadsheet linked to a word document. The word document
justs posts numbers if I use a date format in excel. If I format excel as
text it displays the date as entered MM/DD/YY.

Is there a way to keep my excel date format and have word display date in
text and numbers, like"July 13,2005"

See "Date-Time Picture (\@) field switch" in Word Help).




In article ,
"Earl" wrote:

I have an excel spreadsheet linked to a word document. The word document
justs posts numbers if I use a date format in excel. If I format excel as
text it displays the date as entered MM/DD/YY.

Is there a way to keep my excel date format and have word display date in
text and numbers, like"July 13,2005"