Pasting cell values doesn't remove the formula

  • Thread starter Thread starter HT
  • Start date Start date
H

HT

WindowsXP
Excel2003

I select all, copy, go to a new sheet, edit, paste special, values..its
pastes different numbers and not the number that I previously had on the
sheet.
 
If you select the cell in the original range that looks different after you
paste it, what do you see in that cell?

What do you see in the formula bar for that cell?

Any chance you're copying a range that has hidden rows/columns? Or even pasting
to a range that has hidden rows/columns?
 
Back
Top