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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Back
Top