MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Copying Cells without formula


Posted by David on December 20, 2001 2:20 AM

Does anyone know if it is possible to copy the numbers which appear in the cells wihtout copying the formula, co say i had a formula in cell A1, which gave thevalue 3 in A1, is it possible to copy and paste the value 3, without copying the formula?
Hope that made sense, please reply if you can help
thanks


Posted by Lewis (1) on December 20, 2001 2:39 AM

Try
Copy
Paste Special
Value