How do I delete formulas but save numbers?
 

How do I delete formulas but save numbers?

How do I delete formulas but save numbers?
 

Hi Dino,

Select the range, copy and paste special values

HTH
Regards from Brazil
Marcelo

"Dino" escreveu:

How do I delete formulas but save numbers?

How do I delete formulas but save numbers?
 

Choose the range of formulas and copy it. Then, select the same or other
range and choose Paste Special, Values.

Hope it helps


--
oteixeira
------------------------------------------------------------------------
oteixeira's Profile: http://www.excelforum.com/member.php...o&userid=35320
View this thread: http://www.excelforum.com/showthread...hreadid=555617

How do I delete formulas but save numbers?
 

thank you!

"oteixeira" wrote:


Choose the range of formulas and copy it. Then, select the same or other
range and choose Paste Special, Values.

Hope it helps


--
oteixeira
------------------------------------------------------------------------
oteixeira's Profile: http://www.excelforum.com/member.php...o&userid=35320
View this thread: http://www.excelforum.com/showthread...hreadid=555617

How do I delete formulas but save numbers?
 

Thank you!

"Marcelo" wrote:

Hi Dino,

Select the range, copy and paste special values

HTH
Regards from Brazil
Marcelo

"Dino" escreveu:

How do I delete formulas but save numbers?