Excel is a pain as it chooses the data type based on the data in the first ten or so rows so US zip codes look like numbers unless you edit the excel to include a quote in front.

If using flat file import, you can edit your flat file connection manager and set both delimiter (comma usually) and then text qualifier as " so it strips any quoted text.