how do you formula's but leave the value.

C

craig

hi,how do you formula's but leave the value.
if a1=1 and b1=2 and you have a code in c1 that says
=a1+b1

c1 value would = 3

but how do you then delete the formula so that is stays
as 3.

i hope you understand what i mean.
 
J

JulieD

Hi Craig

copy (don't cut) C1 and then click on C1 again and choose Edit / Paste
Special
now choose values
and click Ok

this should give you what you want

Regards
julie
 
A

Andy B

Craig

Select the cell - or range - then Edit / Copy / Edit / Paste Special /
Values.

Andy.
 
Top