View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernard Liengme Bernard Liengme is offline
external usenet poster
 
Posts: 4,393
Default remove muliplication function and see the original figure

Are you saying the cells have formulas like =A1*B1 ?

--
Bernard Liengme
MVP Excel
http://people.stfx.ca

"hiran" wrote in message
...
in a worksheet there are number of cells contains result of multiplication
between two numbers. I want to remove all multiplication and want to see
only
the orginal number before multiplication. ie the first number of two
numbers.