Removing a calculation formula leaving the result in the cell

  • Thread starter Thread starter Alan Davie
  • Start date Start date
A

Alan Davie

Is it possible in Excel 97 to remove the calculation
formula and leave the result in the cell?

Thanks
 
Hi Alan!

Use:
Copy > Paste Special > Values > OK

You'll find in toolbars customizing their is a button that you can
pull up to your toolbar that allows you to copy > paste values with
just two clicks.
 
Norman Harker said:
Hi Alan!

Use:
Copy > Paste Special > Values > OK

You'll find in toolbars customizing their is a button that you can
pull up to your toolbar that allows you to copy > paste values with
just two clicks.
Click to expand...


How is that done? The furthest I've gotten is to place the paste special
button on my toolbar..
 
Hi Dave!

It's the Past Values icon you need (It looks like a clip board)

Select the cell with the formula in it
Click the Copy icon
Click the Paste Values icon

You'll find the Paste Values icon in the Edit category of the
customize dialog.
 
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

Calculate elapsed time excluding specific timeframe 10
Show the formula not the result 3
Scrabble Value calculation for Welsh words 0
using the =page! feature to transpose a row to column 0
Hiding Formula Answers in Specific Cells 1
Copying formulas across columns 2
cell reference of a formula 2
Calculations 1

Back
Top