If you only want to paste the values, copy the data. if you have a lot, copy all the data, and then right click the cells where you want the value entered. On the drop down menu select PASTE SPECIAL and then click VALUES and that should do it.