If you have done, this in Ms.Excel, then Select the entire column in which you have this data, Click on Format/Cells a dialog box is displayed, Click on Number if Number tab is not displayed, select the required format and click ok. this should solve your problem.
If in Ms.Access, then format...