The easiest way is to copy the cell and do a Paste Special in your Word document, choosing the link option.
The only problem is I need the number that is pulled from excel to look like it is just type in along with all of the other words as part of the sentence. I tried pasting as a link and it inserts what looks like a spreadsheet cell into the word document. Also, it does not put it in the right place.
Thanks,
Kevin
Specifically, this is what I am trying to do: I have a word document that contains sentences similar to this:
"There was an increase in total operating revenues for the nine-month period ended September 30, 2001, when compared to the same period in 2000, of $100,000, or 2.5%."
What I would like is for the $100,000 and the 2.5% numbers to automatically update themselves based on the data in the spreadsheet, but for presentation purposes they need to look like they do above, like they are part of the sentence typed in word, and I don't want it to look like an excel link.
Thanks,
Kevin
When you do the Paste Special, make sure you choose the "Formatted Text(RTF)" option.
it works now - much appreciated
kevin