Copying formulae results

[stevie_ray]

Hi,

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

Thank

 

[Andy B]

Hi

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

 

[Paul B]

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 **