1

I'm using mail merge in Word, with the data coming from Excel.

The formula for the data in Excel is number/6 and I limit it to display just one decimal number, e.g. 91.7.

But in Word, it displays as 91.6666666666.

I would like it to show 91.7 in Word as well.

2

When you mail merge, the actual stored value is used, not the displayed value. You need to set the stored value to the number of digits required.

For example if the source value is in A1 you need to use this formula for the mail merge data:

=ROUND(A1/6,1)
3
  • Will try soon mr robinCTS. Thank you sooo much!
    – cliffe
    Jun 30 '18 at 15:36
  • Hi robinCTS..still not good..some of my data still display like 97.0000000003..more 0 this time..
    – cliffe
    Jun 30 '18 at 16:37
  • @cliffe I don't know how that's possible. It should have worked. However, try =TEXT(A1/6,"0.0") instead.
    – robinCTS
    Jun 30 '18 at 16:49

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.