visible formula

[Guest]

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

 

[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

 

[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).