Thank you for your help. What happened when I copied the column from one
file to another file was the "value" error popped up and I didn't know how to
have it copy just the number...now I've learned about the pasting option of
value only. I thank you very much.

"JE McGimpsey" wrote:

Format will not cause a #VALUE! error.

You can use Edit/Paste Special, selecting the Values radio button, to
paste just the value, but I don't think that will solve your problem.
What formula are you using that you get a #VALUE! error, and what value
are you pasting in?



In article ,
"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?