Excel 2007 Loses Formula Detail

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?
 
J

Jacob Skaria

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
 
S

samcham

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.
 

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

Top