Prev: TITLE FOR A ROW GROUP
Next: if(iserror()) question
From: SBongiov on 19 Jan 2010 08:37
We received a file and are trying to sum columns but when the person enters
the formula the formula stays visible but not the actual value. I've never
run across this before.
From: "David Biddulph" groups [at] on 19 Jan 2010 09:04
You've probably got the cell formatted as text. Format as General (or
Number) & re-enter the formula.
--
David Biddulph

"SBongiov" <SBongiov(a)discussions.microsoft.com> wrote in message
news:85781AA1-FE61-4351-A221-A01B63172585(a)microsoft.com...
> We received a file and are trying to sum columns but when the person
> enters
> the formula the formula stays visible but not the actual value. I've never
> run across this before.


From: Paul C on 19 Jan 2010 09:07
The offending cell is probably formatted as text. Change the formatting to
general and reenter you formula.
--
If this helps, please remember to click yes.


"SBongiov" wrote:

> We received a file and are trying to sum columns but when the person enters
> the formula the formula stays visible but not the actual value. I've never
> run across this before.
From: Eduardo on 19 Jan 2010 09:34
Hi,
hit

CTRL + ~ + Enter

"SBongiov" wrote:

> We received a file and are trying to sum columns but when the person enters
> the formula the formula stays visible but not the actual value. I've never
> run across this before.
 | 
Pages: 1
Prev: TITLE FOR A ROW GROUP
Next: if(iserror()) question