Display the results not the formula in the task bar

How do I display the results of a function in the task bar. I have set up a
function from three adjacent columns the results are displayed in a fourth
column but I would like to remove the function whilst keeping the results in
column 4 how do I do this?

You can do this by selecting column 4, Edit>Copy, Edit>PasteSpecial>Values.
Note: this will permanently remove your formuals so that changes to the
first 3 columns will no longer be reflected in column 4. Be sure that
this is what you want before proceeding and save your work first as a
precaution.

Regards
Rowan

Paul K. wrote:
> How do I display the results of a function in the task bar. I have set up a
> function from three adjacent columns the results are displayed in a fourth
> column but I would like to remove the function whilst keeping the results in
> column 4 how do I do this?

Or, more simply, press F2 (edit), then press F9 (calc), then press Enter.

Pip pip

"Rowan" wrote:

> You can do this by selecting column 4, Edit>Copy, Edit>PasteSpecial>Values.
> Note: this will permanently remove your formuals so that changes to the
> first 3 columns will no longer be reflected in column 4. Be sure that
> this is what you want before proceeding and save your work first as a
> precaution.
>
> Regards
> Rowan
>
> Paul K. wrote:
> > How do I display the results of a function in the task bar. I have set up a
> > function from three adjacent columns the results are displayed in a fourth
> > column but I would like to remove the function whilst keeping the results in
> > column 4 how do I do this?
>

That would be more simple if the OP only wanted to edit one cell but I
don't see how it will work for an entire column.

Regards
Rowan

Boris Merryweather wrote:
> Or, more simply, press F2 (edit), then press F9 (calc), then press Enter.
>
> Pip pip
>
> "Rowan" wrote:
>
>
>>You can do this by selecting column 4, Edit>Copy, Edit>PasteSpecial>Values.
>>Note: this will permanently remove your formuals so that changes to the
>>first 3 columns will no longer be reflected in column 4. Be sure that
>>this is what you want before proceeding and save your work first as a
>>precaution.
>>
>>Regards
>>Rowan
>>
>>Paul K. wrote:
>>
>>>How do I display the results of a function in the task bar. I have set up a
>>>function from three adjacent columns the results are displayed in a fourth
>>>column but I would like to remove the function whilst keeping the results in
>>>column 4 how do I do this?
>>