how do you formula's but leave the value.

  • Thread starter Thread starter craig
  • Start date Start date
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.
 
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
 
Craig

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

Andy.
 
Back
Top