Extra spaces in a copy/paste from Excel into Word as a link with HTML formatting


Joined
Mar 13, 2013
Messages
1
Reaction score
0
Hi,

I have a very simple sheet in Excel 2010 with basic conditional formatting: red if the number is negative, green if it is positive. I applied a number code to add a plus sign or minus sign in front of the number depending on how it gets calculated:

Code:
+#,###;-#,###

The problem is that when I copy/paste any cell into Word 2010 as a link with HTML Formatting, extra spaces get added above and below the number as if there is some extra padding applied. When in Word, I hit ALT-F9 to see the display codes and all I see is this:

Code:
{ LINK Excel.Sheet.12 "C:\\My Documents\\Temp\\Book1.xlsx" "Sheet3!R22C9" \a \f 4 \h }

The extra space above and below even occurs without any of my conditional formatting. If I open up a brand new sheet, type in a number, then copy/paste that into Word as a link with HTML formatting, the spaces still get added. If I try to delete the spaces in Word then it deletes the entire thing because its all part of the same cell.

What am I missing here and how do I eliminate those extra spaces? I've already tried word wrapping, aligning the cells left, justifications, etc. Nothing works!

thanks for your help!!
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top