Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Jim Jim is offline
external usenet poster
 
Posts: 192
Default mail merge shows numbers for dates

do you have a mailmerge where 12/14/2008 in the spreadsheet is turning into
39800 in your word document?

first, make sure that all of your spreadsheet cells are in general format
(format, cells, choose the general format).

then, do NOT use just the date or other info that excel automatically
changes to a pre-set format (without even showing it to you). so for example,
for 12/14/2008--change it to: On 12/14/2008

close your excel and word merge documents.

reopen them.

it will now work.

Reply
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
Mail Merge and Dates Es Microsoft Word Help 1 September 5th 08 11:40 AM
Using dates during mail merge gjupp Mailmerge 26 February 15th 08 08:03 AM
Mail Merge Dates coyotem78 Mailmerge 3 August 4th 06 09:21 PM
Mail Merge and dates Jsampson Microsoft Word Help 3 May 3rd 06 03:52 PM
Using If Then and Else with dates in a mail merge macropod Mailmerge 1 March 28th 05 11:29 PM


All times are GMT +1. The time now is 08:55 PM.

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"