visible formula

[Caseybay]

In my worksheet, I have to total several groups of numbers. I select the sum
function icon and highlight the field. All worked fine except one, which
instead of printing the answer, printed the formula (=SUM H51:H54). I can see
where the cell is formatted any differently than the others.

[Paul B]

Caseybay, sounds like the cell was formatted as text, change it to something
else and try it again
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Caseybay" <Caseybay@discussions.microsoft.com> wrote in message
news:FE8D0538-2E55-4550-BEA7-08DFE639D390@microsoft.com...
> In my worksheet, I have to total several groups of numbers. I select the
> sum
> function icon and highlight the field. All worked fine except one, which
> instead of printing the answer, printed the formula (=SUM H51:H54). I can
> see
> where the cell is formatted any differently than the others.

[Gord Dibben]

Casey

This usually indicates that the cell was pre-formatted as Text.

Re-format to General then hit F2 and ENTER to see results.


Gord Dibben Excel MVP

On Mon, 24 Oct 2005 12:53:04 -0700, "Caseybay"
<Caseybay@discussions.microsoft.com> wrote:

>In my worksheet, I have to total several groups of numbers. I select the sum
>function icon and highlight the field. All worked fine except one, which
>instead of printing the answer, printed the formula (=SUM H51:H54). I can see
>where the cell is formatted any differently than the others.

[Cutter]

I think your problem is the brackets. Reposition the first one so that it follows the word SUM and Excel will recognize the entry as a formula.

Instead of having (=SUM H51:H54) change it to read =SUM(H51:H54).