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.


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

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