Newbie challenge - formula

Can anyone help me, please?

I need to do a calculation but without the formula being referred to in the target cell.
ie. Just the answer. (number)

I have seen it done, and it looked simple but I just can't figure it

Thanks

BD

PS. On Windows 10 now, not 95.

This requires VBA (or copy/paste values).

Try something like this:

Please Login or Register  to view this content.

This will take the sum of A1 and B1 and put the result (not the formula) in C1.

SOLVED.
Thank you very much, also discovered the copy option which just takes the sum total.
Very helpful
BD

You're welcome. Happy to help.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.