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 ?
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:
>
> 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 ?
--
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)
"Drew Cutter" <[email protected]> wrote in message
news:[email protected]...
> 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 ?
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:
> 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:
>> 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 ?
>
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:
>
> 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:
> > 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:
> >> 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 ?
> >
--
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:
> 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:
>> 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:
>>> 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:
>>>> 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 ?
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks