Removing a calculation formula leaving the result in the cell

A

Alan Davie

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

Thanks
 
N

Norman Harker

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.
 
D

Dave R.

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..
 
N

Norman Harker

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.
 

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

How to remove external organization from Office. 0
MS Project. Real progress of the project, % complete 1
Remove Identical words 0
Copy addition formula of non-consecutive horizontal cells 2
Calculate After hours 3
Calculate elapsed time excluding specific timeframe 10
Can I add a formula or function to Vlookup? 1
Copying formulas across columns 2

Top