How do you change cells with formula's to the value or text?

J

jacques

In lotus it is possible to change the formula in a cell to the text or the number that that formula returns. Of course, you can not reverse it, but in is very helpful sometimes. Is that possible in Excel
 
K

Ken Wright

CTRL + ~ will toggle between formulas and values

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL2K & XLXP

----------------------------------------------------------------------------
Attitude - A little thing that makes a BIG difference
----------------------------------------------------------------------------



jacques said:
In lotus it is possible to change the formula in a cell to the text or the number that
Click to expand...
that formula returns. Of course, you can not reverse it, but in is very helpful sometimes.
Is that possible in Excel
 
K

Ken Wright

Oops - meant to say:-

CTRL + ` (Key under the Esc key, top left on the keyboard)
 
Top