Copy the cell, then Edit/ Paste Special/ Values.
--
David Biddulph

"amol" wrote in message
...
hi u r help will be appreciating

if i calulate a value in particular cell with reference to other cell and
now how can i keep only calculated data n not the formula may it be in
same
cell or other cell if i copy i

eg if i calculate sum of cel A1 and B1 in cell C1 i want is the c1 should
show only the value attend and not the formula viz a plain figure