Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
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 | |
|
|
Similar Threads | ||||
Thread | Forum | |||
NO CODE - mail merge to Outlook with attachment with CC | Mailmerge | |||
How to get all mail merge fields in a document | Mailmerge | |||
Adding a field to an Off 97 mail merge using Office Pro 2003 | Mailmerge | |||
Mail Merge Losing Data | Mailmerge | |||
mail merge with attachments | Mailmerge |