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 answers

  1. 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
    1. Roro
       
      Well done,
      I did exactly what was noted, and it works.
      That's great.
      Thank you.
      0
      1. 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
    2. bob
       
      thank you super
      0