using MS Word to insert Excel Object with Paste Special Leaves unwanted 0's
Hello, I am using Excel and MS Word. we use Excel for pricing and have a nice detailed table for this, we then copy and paste the table (manually) into word for our proposals.
I want to create a link between the excel pricing and MS word.
what I did was insert an excel worksheet object into word.
Then copied the pricing from excel
Went back to word and inside the excel object I used the PASTE SPECIAL
checked the "Link" Check box
and the data matched correctly and links do indeed work HOWEVER....
I am left with unwanted ZEROS for each blank cell that was copied and pasted with the Paste special "Link" option
Is there anyway to remove these zeros?!?!?!
I do know that within Excel there is an option with File --> Options --> Advanced --> under the Display Options, uncheck the box labeled "Show a Zero in cells that have a zero value"
