Formulas and numerical value of answers

[olitong]

Hi all,

Whenever we have a formula, is it possible to convert the formulas (of
different cells of an entire worksheet) into the actual values?

e.g. Formula of C3 = C1 + C2, (C1 = 1 ; C2 = 1)
so instead of seeing C1 + C2 when C3 is highlighted, you will see the
numerical answer 2.

Thanks in advance.

 

[Pete_UK]

Select the cell(s) you want this to happen to, then click <copy> then
Edit | Paste Special | Values | OK and <esc> or <enter>

Pete

 

[Niek Otten]

But that will destroy the formula, so if C1 changes, C3 will not change
accordingly.
Do you really mean you don't want to see the formula in the formula bar? The
value is shown in the highlighted cell, isn't it?

 

[olitong]

Yup, that's right, I just want to extract out the actual numerica
values.

Oh thanks Pete, that worked.

Regards.