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