View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
amol amol is offline
external usenet poster
 
Posts: 4
Default keeping only data in cell and not formula

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