View Single Post
  #1   Report Post  
stevenpwhite stevenpwhite is offline
Junior Member
 
Posts: 3
Default Help please, excel format conversion

I have thousands of numbers in a colum in the following format 1/234567/890 and need to convert them into this format 123-456789-0. Could someone please advise on a formula for this conversion. I will be eternally grateful

love steve