In addition to this What excel does is it checks for first few columns and excel connection manager just blindly assigns a data type. In your case the datatype assigned in Integer for the column so you cannot have 9,13 in iteger field and hence You have no data in that fields.
In MS EXCEL Format the column as TEXT and re create connection manager for this and you should get the results.