View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Be18 Be18 is offline
external usenet poster
 
Posts: 16
Default Symbol or text after number to used in sum

Please could you tell me if it is possible to insert a symbol or a letter
after a number in the same cell and still use the number in that cell in a
sum? For example i want to put 11.5* in B1, 11.5 in b2, 15 in b3 and add the
3 numbers togteher excluding the astreick in b4) Thank you