Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
MervynW1954
 
Posts: n/a
Default Mailmerge calculated dates from Excel

If I calculate a date in excel I can format it as dddd d mmmm yyyy (for
example)

(I want to calculate the date, at three weeks before a date entered for
example).

However, if I use this in Word, it displays the date as a number only. By
using the switch I cannot get it to format as I want it (as above). It
displays only as a number. I never had this problem with Office 2000. A
date that I have manually entered in the spreadsheet displays correctly.

Any ideas
 
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Mailmerge on word using excel data RJP Mailmerge 4 April 11th 05 08:29 AM
enter an excel module global variable value in a mailmerge letter windowed Mailmerge 1 March 22nd 05 09:31 PM
Mailmerge using Excel via DDE zeph317 Mailmerge 1 February 27th 05 09:08 PM
Mailmerge from EXCEL, custom format problem TonyB Mailmerge 1 December 1st 04 04:41 PM
Excel dates formatted d/m/yy convert to m/d/yy in mail merge GayleT Mailmerge 1 November 29th 04 02:43 AM


All times are GMT +1. The time now is 01:57 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"