Fix value with zeros after the decimal point?

Well, I think I found it; you need to format it as a number in the merge field.

In the Word document, you need to press <Alt> F9

then in the field code, put this:

{MERGEFIELD "Montant" \# ####.00}

In my example, the merged field from Excel is called Montant.

Give it a try

Best regards,

Hello,

However, in Excel, it is enough to take the cell format "number" or "currency" with 2 digits after the decimal point.

See you later
Best regards,

Hi,

have you tried changing the cells to text format?

--
A+ Blux

 "Fools dare anything. It's even how we recognize them" 

Hi,
you need to change the cell format to currency and set the number of decimal places to 2.

First of all, thank you for your responses.

That said, even though the cell format (currency or text) gives me a visually satisfactory result (450.6 becomes for example 450.60€), the actual value of the cell (which you see in the formula bar at the top in Excel) remains unchanged.
So I still have 450.6 when I do my mail merge.

It's frustrating, I must be doing something wrong.

Hello,

Excel does not have the nasty tendency to delete zeros after the decimal point; it displays what it sees or what we enter with a standard display.

Furthermore, Excel is capable of displaying a multitude of numbers like phone numbers starting with a 0, postal codes, social security numbers, etc., as well as a user-defined number of decimal places (one, two, three, or more after the decimal point).
Additionally, the monetary unit of a multitude of countries can be displayed; it just needs to be requested from Excel.
To do this, right-click on a cell or range/Cell Format/Number, and there you will find a multitude of options.
--
Best,
Mike-31

A period of failure is a perfect time to sow the seeds of knowledge.

I didn't fully understand the problem. Indeed, if a formatted amount with two decimal places is used in Excel and that amount is referenced by Word in a mail merge, the format is not respected.

I can't find a solution. I haven't tested Blux's solution yet.

See you later.
Best regards,

Hi Mike, if you take into account what I've already tried, you can see that my issue lies elsewhere.

I am well aware of how to change the cell format; my problem is simply that it doesn't work the way I want.
As you mentioned, Excel does exactly what I ask it to, but only visually. The actual value of the cell remains unchanged. This is the specific point I do not understand.
Thus, my value of 450.6 becomes 450.60€ in my Excel sheet, but it reappears as 450.6 during the mail merge.
I hope you have a better grasp of my problem now.

(note: for fun I tried changing the Word switches by adding \#,## but nothing works)

Hello

the simplest way might be to transform your formula results to reduce the number of decimals numerically for Excel:
In your table, instead of
= formula

use:

=ROUND(formula, 2)

which will round to two decimal places

ROUNDUP to round up
ROUNDDOWN for the lower decimal.

Best regards
--
Let's ask ourselves if we're not the only ones who understand what is being explained?

Thank you very much, Pilas! I can finally stop pretending to work. So it was in Word, I was almost on the right track :p

Thanks to everyone for your contributions, have an excellent day.

Vaucluse, thank you for your message. I had thought about that too, but it didn't work in my case. The "zeros" were still not taken into account in Word during the mail merge.

Hi,

the problem comes from a setting in Word

Microsoft button/Excel Options/Advanced Options section/at the end of the General list check Confirm conversions at Open

save/close the files and reopen the Word file for the conversions to take effect

--
Cheers
Mike-31

A period of failure is a perfect time to sow the seeds of knowledge.