View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Patrick[_5_] Patrick[_5_] is offline
external usenet poster
 
Posts: 7
Default No Dashes, please?

how do i use the value of a cell without the dashes?

For example

range(A1) = "123456-4434"

i want to use that number in an equasion as "1234564434"

thanks