Memory failure : Getting Sum to work

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Drew Cutter - 25 Apr 2006 16:45 GMT

I added the number 200 3 times (vertical) . Got the correct answer but i
can't seem to get the answer to appear in the total cell. Just the
formula shows up . What am i doing wrong ?

Reply to this Message

Dave Peterson - 25 Apr 2006 17:11 GMT

Format the cell with the formula as General (or number--just not text).

Then with that cell selected, hit F2 followed by enter.

> I added the number 200 3 times (vertical) . Got the correct answer but i
> can't seem to get the answer to appear in the total cell. Just the
> formula shows up . What am i doing wrong ?

Signature

Dave Peterson

Reply to this Message

Drew Cutter - 25 Apr 2006 18:39 GMT

Didn't seem to work . I used the currency format. Maybe i need a step by
step explanation. Use column C3 , C4 , C5 . 250 , 300 ,400 . I get the
correct total , just not in the format that i want . Need to hide the
formula in the final box C6.

> Format the cell with the formula as General (or number--just not text).
>
[quoted text clipped - 3 lines]
>> can't seem to get the answer to appear in the total cell. Just the
>> formula shows up . What am i doing wrong ?

Reply to this Message

Dave Peterson - 25 Apr 2006 18:44 GMT

If you get the correct result for your formula, then you should be able to use
Format|cells|Number tab to make the cell display the formatting you want.

If you lock the cell (format|Cells|protection tab)
and then protect the worksheet (tools|protection|protect sheet)

the formula will will be hidden.

> Didn't seem to work . I used the currency format. Maybe i need a step by
> step explanation. Use column C3 , C4 , C5 . 250 , 300 ,400 . I get the
[quoted text clipped - 8 lines]
> >> can't seem to get the answer to appear in the total cell. Just the
> >> formula shows up . What am i doing wrong ?

Signature

Dave Peterson

Reply to this Message

Drew Cutter - 25 Apr 2006 19:35 GMT

As nearly as i can tell its only happen on this worksheet. Try to clean
it out of all things possible that preventing from doing a simple thing
like adding. Open up a new work sheet , no problems.

> If you get the correct result for your formula, then you should be able to use
> Format|cells|Number tab to make the cell display the formatting you want.
[quoted text clipped - 16 lines]
>>>> can't seem to get the answer to appear in the total cell. Just the
>>>> formula shows up . What am i doing wrong ?

Reply to this Message

Bob Phillips - 25 Apr 2006 17:12 GMT

It sounds as though the cell is formatted as text. Change it to a format of
General, hit F2 and Enter.

Signature

HTH

Bob Phillips

(remove nothere from email address if mailing direct)

> I added the number 200 3 times (vertical) . Got the correct answer but i
> can't seem to get the answer to appear in the total cell. Just the
> formula shows up . What am i doing wrong ?

Reply to this Message