如何在Excel中设置IMEX = 1

I am using OS Windows 7 and Office 2010 and SQL Server 2008/2008R2/2012. I am trying to import excel sheet to SQL Server. One column has several Numeric and Text values as well. While importing data from excel, numeric values are not getting imported. First row of excel sheet has headers. Many of the blogs have suggested to update IMEX=1. But I could not find how and where IMEX value has to be set to 1. Please helpI am using OS Windows 7 and Office 2010 and SQL