When I create an equation in a column...how can I get excel to only show the
number in the cell when I click on it rather than have it show the equation
used to obtain this value?

Perhaps the cells are preformatted as TEXT, or your formulas might not have
the equal sign preceeding them.

Vaya con Dios,
Chuck, CABGx3


"Brad" wrote:

When I create an equation in a column...how can I get excel to only show the
number in the cell when I click on it rather than have it show the equation
used to obtain this value?

On Apr 23, 12:56 pm, Brad wrote:
When I create an equation in a column...how can I get excel to only show the
number in the cell when I click on it rather than have it show the equation
used to obtain this value?

Do you mean in the Formula Bar? Or right in the cell?

The formula should show in the Formula Bar, the value should show in
the cell. Unless you double click on the cell, which means you are
editing it and the formula should then show in the cell.

Hi,

You can use Excel's protection feature to hide the formulas.

--
Regards,

Ashish Mathur
www.ashishmathur.com
http://www.linkedin.com/in/excelenthusiasts

"Brad" wrote in message
...
When I create an equation in a column...how can I get excel to only show
the
number in the cell when I click on it rather than have it show the
equation
used to obtain this value?