Copying formulae results

  • Thread starter Thread starter stevie_ray
  • Start date Start date
S

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
 
Hi

When you paste the result, use Edit / Paste Special / Values (or select this
option from the right-click menu)
 
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 **
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help: Using CONCATENATE (and a COUNT?) for a total result 3
Copying concatenate not returning correct cell information 6
Stock Copying 1
Formula returned instead of result 3
make a minus a zero 2
Hide Formula & Allow Copy 1
Formulas 3
Temp variables within formulas? 2

Back
Top