This worked for me in Excel 2010/16. Just select the column, right click, Format cells, Custom and choose the option that says 0 (second option below General).