View original (French)

Date and time format on a Word mail merge

Solved
Joek -  
 bob -
Hello,

when I merge an Excel table into Word with date and time columns, the Word document presents them in American format.
I haven't found a way to change this format.
Could someone please help me?

Thank you
Configuration: Windows XP Internet Explorer 6.0

3 réponses

Réponse 1 / 3
anonyme
 
Right-click on the field to customize, field modification,
field code... and for the date put: nom_champs_fusion \@ "dddd d MMMM yyyy"
for the time: nom_champs_fusion \@ "HH:mm"

I just had the issue.
23
Roro
 
Well done,
I did exactly what was noted, and it works.
That's great.
Thank you.
0
CHC > Roro
 
Same problem, but it gives me the result of a calculation, for example 0703, instead of the time. However, in Excel, there is indeed a time format displayed correctly.
0
bob
 
thank you super
0