Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
rexmann
 
Posts: n/a
Default mail merge

Hi all

I am not sure if this is an excel or word mail merge problem so sorry if it
is in the wrong bit.

When I mail merge in word using an excel data source the following problems
occur:

1) The dates convert from UK to USA format (day month switches) so the wrong
date is shown (eg 10/03/06 becomes the 03/10/06). I have tried to find an
option in excel and word but have not done so. The only thing I can do is
display as text (3rd October 2006). Is it possible to stop the conversion?

2) equally recuring numbers in excel appear in the word mail merge (eg 4.99
sometimes appears as 4.999999999). This happens even when I set it to two
decimal places in excel. Can this be stopped?

Any help greatly appreciated

Cheers Rexmann

PS I am running Word and Excel XP (2002)




 
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
NO CODE - mail merge to Outlook with attachment with CC BrianH Mailmerge 1 February 10th 10 02:53 PM
How to get all mail merge fields in a document [email protected] Mailmerge 3 February 17th 06 05:43 AM
Adding a field to an Off 97 mail merge using Office Pro 2003 TomC Mailmerge 1 January 5th 06 08:00 AM
Mail Merge Losing Data Scott May Mailmerge 1 November 1st 05 11:03 PM
mail merge with attachments AS Mailmerge 5 April 9th 05 09:49 AM


All times are GMT +1. The time now is 09:27 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"