View original (French)

Mail merge a date from Excel in Word

Solved
refpons Posted messages 4 Status Member -  
 remibeauclair -
Hello,
I want to merge a date from an Excel table into a Word form. In the Excel table, the date column has a standard format because I also use this table for queries.
When I merge, the date loses its format: dd/mm/yyyy.
Can you help me?
Thank you.

Configuration: Windows / Chrome 42.0.2311.135

2 answers

  1.
    Mike-31 Posted messages 18205 Registration date   Status Contributor Last intervention   5 147
     
    Hello,

    Create a new column that will serve as a merge field for the dates, replacing the current one. For example, your dates in Excel are in column A
    adapt this formula

    =TEXT(A1,"dd/mm/yyyy")

    A+
    Mike-31

    A period of failure is a perfect time to sow the seeds of knowledge.
    5
    1. refpons Posted messages 4 Status Member
       
      Thank you, Mike,
      This solution is effective. It saves me from having to type the date.
      Last year, I had another solution without adding a column. I would write a formula in the form that looked like "MERGEFIELD title column \@ dd/MM/yyyy". This year, I can't find the form formula because I overwritten it....
      Best regards,
      0
    2. remibeauclair
       

      The most effective solution, the least time-consuming, we don't think about it but on top of that it's disconcertingly easy, thank you, I had wasted a day with MERGEFIELD and I was going in circles and now, the solution came to me.

      0