The problem you're encountering is not with Mathematica, but with Excel. When you import directly from Excel, Mathematica is able to bring in whatever is actually visible in the cells, and that is dependent on the actual cell format. If you change the format of the cells, then you'll see different results. Importing, by first exporting to a CSV works because then Excel will ignore the cell format and output everything it has.