Software

Ask something
Discussion Locked

Rounding numbers when copying into Word

0 helpful
3 replies

by garyslywchuk

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Is there a way to copy a cell from Excel to Word and get it to round out the
numbers in Word only?

3 replies

by dklippert

You can add a numeric picture formatting to the field. Show the field with Shift+F9. At the end of the field enter a space and then \# 0.
A linked field may look like this:

{LINK Excel.Sheet.8 "Book1" "Sheet1!R11C7" \a \r \# 0}

BTW be sure torefresh the data by hitting F9 after applying the formatting switch.

This discussion is closed to new replies.