how do i change a formula to its value

's Computer Specifications

After a range has calculated the answer from a formula, how can I change the
same range to the value displayed?

's Computer Specifications

Select your range > copy > paste special > values > OK

"Davy" wrote:

> After a range has calculated the answer from a formula, how can I change the
> same range to the value displayed?

's Computer Specifications

Copy and paste special as values

--
Regards,

Peo Sjoblom

"Davy" <(E-Mail Removed)> wrote in message
news:EE11D064-A960-45F6-9808-(E-Mail Removed)...
> After a range has calculated the answer from a formula, how can I change
> the
> same range to the value displayed?

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Why are the two codes below not getting the right formula for myworksheet event change formula?	Damil4real	Microsoft Excel Worksheet Functions	5	18th Nov 2009 06:02 PM
Why are the two codes below not getting the right formula for myworksheet event change formula?	Damil4real	Microsoft Excel Programming	2	18th Nov 2009 05:49 PM
formula or macro to change a formula in muliple spreadsheets	mel.pilgrim@agr.gc.ca	Microsoft Excel Programming	1	21st May 2009 05:27 PM
change color of all cells with formula or are part of a formula	everythingautomotive@gmail.com	Microsoft Excel Misc	19	28th Jan 2008 01:21 AM
copy formula down a column and have cell references change within formula	brad	Microsoft Excel New Users	5	13th May 2007 04:38 PM