I am copying figures from one spreadsheet to another. The figures are in a cell which contains formula i.e. =C6;C79. I want to show only the figures (sums) on new sheet how do I do this? I used to know but have forgotten.

I don't know of any formula that looks like =C6;C79. What is that suposed to do?

As for your question, try Copy...Paste Special...Values.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Sorry full formula is =SUM(D3:D35). and the total could be £3765.10 but when you copy and paste you get the above formula rather than the amount in figures. However, I have solved it by finding out that when I paste I need to paste 'value' rather than just paste. Thanks for reply.

uh...that's exactly what I said in my post.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Ask Your Question

Weekly Poll

Do you think manufacturers should do more to reduce phone and tablet usage among kids?

Discuss in The Lounge

Poll History