Excel 2007 Loses Formula Detail

  • Thread starter Thread starter samcham
  • Start date Start date
S

samcham

I'm new to Excel 2007. I've noticed that when I enter a formula in a cell
(such as =2*6*4) Excel will change the formula to its value, in this example
3.

I would like to keep the detail. How can I turn this off?
 
Format the cell to Text before entering (Right click>FormatCells>select Text)

Or

Prefix with a apostrophe like
'2*6*4

OR

If you want to display your formulas; you can hit the key combination Ctrl + ~


If this post helps click Yes
 
Thanks for the reply, Jacob.

I need to see and use the results of the formula, so the first two options
won't work.

The problem is that Excel is changing the cell contents, effectively erasing
the formula and replacing it with the result. That's what I need to turn off.
 
Back
Top