Thank you...I was able to copy from one file to another by using that values
radio button. I didn't want to lose the integrity of the original file, but
I needed just the column results in the other. You have been very helpful

"Sloth" wrote:

What does the format have to do with the "value" error? Do you mean a
formulated result? I take it you are trying to paste the result of a formula
into an empty cell? In that case simply copy the cell with the formula and
right click where you want to paste, and then select paste special. Select
values and hit ok. This will paste the result of the formula. It might be
better to just input a formula like this...

=Sheet1!A1

This would be if the cell with the formula was in cell A1 of sheet1. That
way if the cell changes, then so will this one. Hope this helps.

"loliemargaret" wrote:

I have a formatted sheet with an end result in a formatted cell. I want to
take that column and copy it to another sheet but minus the format since I
get the "value" error. How can I just get the numbers as numbers?