Pasting cell values doesn't remove the formula

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.
 
D

Dave Peterson

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?
 
B

BlueDaze

Instead of selecting all, try only selecting the range of cells that you
want to copy.
 
Top