Changing a calculation to an actual number

C

CMcGrann

Is there a way in Excel to change a calculated field to an actual number?
For example changing =B2 (10)+C2 (12) to actually be 32? I want to use this
field in a seperate system, can it will not copy since it is a calcuated
field. Thanks.
 
M

Mike H

Hi,

Select the fomula cell and copy it and while still in that cell
edit|Pastespecial
select Values
Click OK


Mike
 
Top