Prev: "seeing" hyperlinks in a worksheet
Next: HELP! Lookup
From: Louise on 9 Apr 2010 09:36
i am trying to enter a formula in a cell, but it is coming up as a value.
how do i change it from value to formula.
--
Louise
From: Gilbert on 9 Apr 2010 10:05
Isn't the formula supposed to return a value? Maybe something in the
conditional formatting.

"Louise" wrote:

> i am trying to enter a formula in a cell, but it is coming up as a value.
> how do i change it from value to formula.
> --
> Louise
From: מיכאל (מיקי) אבידן on 9 Apr 2010 10:08
Precede the formula with an apostrophe
Micky


"Louise" wrote:

> i am trying to enter a formula in a cell, but it is coming up as a value.
> how do i change it from value to formula.
> --
> Louise
From: Bob I on 9 Apr 2010 11:41
(Excel 2007) Click Formulas tab, then Show Formulas

Louise wrote:

> i am trying to enter a formula in a cell, but it is coming up as a value.
> how do i change it from value to formula.

From: Reeza on 9 Apr 2010 11:55
On Apr 9, 6:36 am, Louise <lou...(a)aol.com> wrote:
> i am trying to enter a formula in a cell, but it is coming up as a value.  
> how do i change it from value to formula.
> --
> Louise

Use the apostrophe at the beginning or CTRL+ ~ used to show all
formula's in a worksheet. Useful for checking things.
 | 
Pages: 1
Prev: "seeing" hyperlinks in a worksheet
Next: HELP! Lookup