Whenever I link data between and excel and word, I first convert all the numbers to text. For example a simple formula like this:
Formula:
=1/3
would have a lot of decimal spaces I don't want to show. In Excel, I change the way it is displayed (e.g. 2 numbers after the decimal). I can also use a round, etc. The problem is when you link this cell to Word, it still shows a lot of decimal spaces. The trick is to convert the final number to a text:
Formula:
=Text(1/3,"0.00")
Hope this helps.
abousetta
Bookmarks