View original (French)

Number format issue when mail merging Word / Excel

SyloEpervier63 Posted messages 1 Status Member -  
 SyloEpervier63 -

Hello,

During the mail merge in Word, the number format does not transfer correctly from the Excel table.

Example 1: the number in the Excel cell is "15.00" (tens, units, and 2 decimals), in Word it displays as ".15" (the units and tens end up after the decimal).

Example 2: the number in the Excel cell is "6.90" (units and 2 decimals), in Word it displays as ".7" (rounded up, after the decimal).

In the field of my Excel cells, I have { MERGEFIELD xxxyyy \# « ##,00 » }.

This worked very well under Windows 10 and MS365 but hasn't since I had to change my PC equipped with Windows 11!

Can you help me, please?

Thank you in advance.

Sylvain

2 answers

  1.
    Le Pingou Posted messages 12275 Registration date   Status Contributor Last intervention   1 477
     

    Hello,

    Just a quick note regarding the instruction like this { MERGEFIELD xxxyyy \# " ##,00 " }.

    Best regards.
    The Penguin

    1
  2. SyloEpervier63
     

    Hello,

    Thank you very much for your feedback!

    It seems to be working well. I will check my files.

    Have a great day

    0