Paste Special Changes Content

  • Thread starter Thread starter Bill
  • Start date Start date
B

Bill

Greetings - I am attempting to copy and link, via Past
Special, a group of rows within the same workbook. When I
do, all the empty cells are populated with zeros.

I am using Windows 200 and Office XP. Thanks in advance,
Bill
 
When you paste special|Links, you end up with a formula like:

=x99

If x99 is empty, then excel will show a 0. But you can change your formula to
look like this:

=if(x99="","",x99)

(if x99 is empty, then make the cell look empty, else just show what's in x99.)
 
Back
Top