Retain value of cell but remove formula

Does anyone know how to retain the value of a formula in a cell but delete the formula that achieved the result?

Basically, I want to be able to convert the result of a formula to a whole number without having to type it in manually.

Thanks.

MacBook Pro, Mac OS X (10.5.3)

Posted on Jun 12, 2008 8:22 AM

Reply
Question marked as Top-ranking reply

Posted on Jun 12, 2008 8:41 AM

Clay,


First, copy the cell with the formula to the clipboard. Then apply Menu: Edit > Paste Values

That should do it. Welcome to Numbers -- hope all goes well.

pw
2 replies

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Retain value of cell but remove formula

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.