Formulas and numerical value of answers

O

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.
 
P

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
 
N

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?
 
O

olitong

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

Oh thanks Pete, that worked.

Regards.
 
Top