MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Converting a formula into a real number


Posted by danbee on August 27, 2001 8:50 AM

Does anyone know how to convert a cell into a formula into a cell containing a whole number?


Posted by Dax on August 27, 2001 9:01 AM

If you copy the cell in question, then click Edit, Paste Special and choose the Values option you should get what you want.

Regards,
Dax.

Posted by Loren on August 27, 2001 9:27 AM

formula into a real number-there is an icon for this