Limit the number of decimal places shown when I merge Excel-Word

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bill W - 07 Jan 2008 20:53 GMT

I want to limit the number of decimal places displayed on a Word document
when I merge data from Excel into Word. This is testing information which
includes a person'e weight. Instead of 168.2 it shows 168.1999999999. The
weight was entered into the spreadsheet (as opposed to calculated). I have
changed the number of decimal places to display in Excel and that makes no
difference.

Reply to this Message

Doug Robbins - Word MVP - 08 Jan 2008 01:28 GMT

See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
website at

http://www.gmayor.com/formatting_word_fields.htm

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

>I want to limit the number of decimal places displayed on a Word document
> when I merge data from Excel into Word. This is testing information which
[quoted text clipped - 4 lines]
> changed the number of decimal places to display in Excel and that makes no
> difference.

Reply to this Message