I am working on a mail merge right now and have run across an issue I've never seen before: the merged Word doc isn't exactly mirroring the merged field from Excel.
The Excel field is a percentage (not the result of a calculation, but one I typed in and formatted as Percentage with one decimal place). I typed 5.3%
The Merged Field in Word shows 5.2999999999999999E-2.

I have tried editing the Merged Field with no success. There is no way to decrease the numbers behind the decimal in Word.
I have tried converting the Excel field to text, thinking it would work just like my names and addresses. The Merged Field instead shows 0 (zero).
I tried =ROUND(5.3%, 3), but the Merged Field still shows 5.2999999999999999E-2.

Any thoughts on why this issue is occurring and what can be done to fix it?