number formatting

Hi I am currently having issues with formatting a large number of numbers. In my workbook, I have a column containing numbers with dashes "-", and the numbers also have preceding "0's" for example: 0...