View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
readystate readystate is offline
external usenet poster
 
Posts: 25
Default Converting cells to numbers

I have a spreadsheet with a column of numbers formatted as follows

1111-111-111

I need to omit the - in both places so that I end up with just the digits
formatted as numbers. Any suggestions???