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
 
Oops - meant to say:-

CTRL + ` (Key under the Esc key, top left on the keyboard)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula help 1
How to synchronize all cell values? 1
Vlookup - actual value not the formula 3
Change cell format from text to general on the fly 9
Pivot Value not formula 4
Pivot value not formula 1
Vlookup - value not formula 1
Can a text box use a formula or cell reference 3

Back
Top