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 clickFormatCellsselect 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
---------------
Jacob Skaria


"samcham" wrote:

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?

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.


"Jacob Skaria" wrote:

Format the cell to Text before entering (Right clickFormatCellsselect 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
---------------
Jacob Skaria


"samcham" wrote:

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?