To rid yourself of the hash mark open the Excel spreadsheet, highlight the column, press CTL+H (search & replace), put a ' for find what, and nothing for the replace with. This will remove the '.