software

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 ?

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

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

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

--

Dave Peterson

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;Drew Cutterquot; gt; wrote in message
...
gt; I added the number 200 3 times (vertical) . Got the correct answer but i
gt; can't seem to get the answer to appear in the total cell. Just the
gt; formula shows up . What am i doing wrong ?
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.

Dave Peterson wrote:
gt; Format the cell with the formula as General (or number--just not text).
gt;
gt; Then with that cell selected, hit F2 followed by enter.
gt;
gt; Drew Cutter wrote:
gt;gt; I added the number 200 3 times (vertical) . Got the correct answer but i
gt;gt; can't seem to get the answer to appear in the total cell. Just the
gt;gt; formula shows up . What am i doing wrong ?
gt;

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.
Drew Cutter wrote:
gt;
gt; Didn't seem to work . I used the currency format. Maybe i need a step by
gt; step explanation. Use column C3 , C4 , C5 . 250 , 300 ,400 . I get the
gt; correct total , just not in the format that i want . Need to hide the
gt; formula in the final box C6.
gt;
gt; Dave Peterson wrote:
gt; gt; Format the cell with the formula as General (or number--just not text).
gt; gt;
gt; gt; Then with that cell selected, hit F2 followed by enter.
gt; gt;
gt; gt; Drew Cutter wrote:
gt; gt;gt; I added the number 200 3 times (vertical) . Got the correct answer but i
gt; gt;gt; can't seem to get the answer to appear in the total cell. Just the
gt; gt;gt; formula shows up . What am i doing wrong ?
gt; gt;

--

Dave Peterson

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.

Dave Peterson wrote:
gt; If you get the correct result for your formula, then you should be able to use
gt; Format|cells|Number tab to make the cell display the formatting you want.
gt;
gt; If you lock the cell (format|Cells|protection tab)
gt; and then protect the worksheet (tools|protection|protect sheet)
gt;
gt; the formula will will be hidden.
gt;
gt;
gt;
gt; Drew Cutter wrote:
gt;gt; Didn't seem to work . I used the currency format. Maybe i need a step by
gt;gt; step explanation. Use column C3 , C4 , C5 . 250 , 300 ,400 . I get the
gt;gt; correct total , just not in the format that i want . Need to hide the
gt;gt; formula in the final box C6.
gt;gt;
gt;gt; Dave Peterson wrote:
gt;gt;gt; Format the cell with the formula as General (or number--just not text).
gt;gt;gt;
gt;gt;gt; Then with that cell selected, hit F2 followed by enter.
gt;gt;gt;
gt;gt;gt; Drew Cutter wrote:
gt;gt;gt;gt; I added the number 200 3 times (vertical) . Got the correct answer but i
gt;gt;gt;gt; can't seem to get the answer to appear in the total cell. Just the
gt;gt;gt;gt; formula shows up . What am i doing wrong ?
gt;