Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Earl
 
Posts: n/a
Default 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"
  #2   Report Post  
JE McGimpsey
 
Posts: n/a
Default

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"

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
Excel Date Format - users should be able to override it automatic. jamezog Excel Discussion (Misc queries) 7 May 20th 10 02:45 PM
Excel Range Value issue (Excel 97 Vs Excel 2003) Keeno Excel Discussion (Misc queries) 2 June 13th 05 02:01 PM
Excel enters date as a text format Kane Excel Discussion (Misc queries) 3 March 22nd 05 09:20 PM
Inserting Photos into Excel and linking to Word. Uploading Photos Excel Discussion (Misc queries) 0 March 17th 05 08:05 PM


All times are GMT +1. The time now is 04:02 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"