How to round off after a decimal point in Word when merging from Excel?

Question

excel

I'm doing a merge from Excel to Word.
In Excel, the area is 34.4, but when merging in Word, it already shows 34.39999999999999999
How to make Word show the same figure as Excel?
1 Cell properties changed to anything (including plain text)
2 rounding, as advised here, does not help: wordexpert.ru/forum/viewtopic.php?id=116
3 formatting, as advised here, does not help: www. planetaexcel.ru/forum/?PAGE_NAME=read&FID=8&TI...
like this in Excel:

and like this in Word:

Answer 1

Here are two tips for this case:

In order to retain the two decimal places during mail merge, follow the instructions below:
Press alt+f9 > Insert the field code \# "0.00" after the title of the merge field that needs to be limited to two digits after the decimal point .
Example: {MERGEFIELD "Wages"\# "0.00"}
Note: Press Alt+F9 to hide the merge field codes

If it doesn't help - In Excel, create a column\row where the data will be converted to text, and from there merge into Word

You may need to turn you numbers into text
Try this formula: =TEXT(A1,"0.00")
Copy and Paste this as value and replace the orginal data (or simply have as a seperate field).

Answer 2

it helped me: it’s clear that the cell format in excel is numeric with two zeros after the decimal point and ... I closed the file with the base in excel and opened just a Word file and there the numbers were with two zeros after the decimal point, with the base open in excel, after comma in the Word was a bunch of numbers) can help try.