Copying formulae results

Hi,

I am currently creating a stock control spreadsheet for work. I need to
copy a column of formula results to a seperate column (the result only
not the formula). However, when I copy the total it takes the formula
with it and when the numbers are deleted for each item the numbers all
return to zero!

Thanks


---
Message posted from http://www.ExcelForum.com/

Hi

When you paste the result, use Edit / Paste Special / Values (or select this
option from the right-click menu)

--
Andy.


"stevie_ray " wrote in message
...
Hi,

I am currently creating a stock control spreadsheet for work. I need to
copy a column of formula results to a seperate column (the result only
not the formula). However, when I copy the total it takes the formula
with it and when the numbers are deleted for each item the numbers all
return to zero!

Thanks


---
Message posted from http://www.ExcelForum.com/

Stevie, copy and right click paste special valves

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 97
** remove news from my email address to reply by email **
"stevie_ray " wrote in message
...
Hi,

I am currently creating a stock control spreadsheet for work. I need to
copy a column of formula results to a seperate column (the result only
not the formula). However, when I copy the total it takes the formula
with it and when the numbers are deleted for each item the numbers all
return to zero!

Thanks


---
Message posted from http://www.ExcelForum.com/