[andyp161]

When I mail merge from excel to word, the date format I want to merge from Excel, 'dd mmmm', is automatically converted by Word to 'mm/dd/yyyy'. Is there any way that I can either a) merge as 'dd mmmm' or convert back to 'dd mmmm' in Word.

Many thanks

Andy

[Advertisements]

"Typically the way to get the data in the nearest format to the one used to
display the data in Excel is to check Word Tools||Options|General|Confirm
conversions at open, go through the connection process again, then choose
DDE when it is offered. But this requires Excel to be present on the system
doing the merge and a copy of Excel is started which can sometimes create
problems.


i found this at another site...i'm still looking for something bettery..but this might make sense to you

[dsenette]

"Typically the way to get the data in the nearest format to the one used to
display the data in Excel is to check Word Tools||Options|General|Confirm
conversions at open, go through the connection process again, then choose
DDE when it is offered. But this requires Excel to be present on the system
doing the merge and a copy of Excel is started which can sometimes create
problems.


i found this at another site...i'm still looking for something bettery..but this might make sense to you

[dsenette]

this one is better http://homepage.swis...er/MergFram.htm

just look for the "Date format reversed" or something like that

[Nat-UK]

I had that the other day, way I got round it was to re format the call as text only.