I need some help with a spreadsheet project. I am not a frequent or skilled user of Excel 2013 and I am having a few problems in which there is likely an easy fix by someone more knowledgeable and experienced than me.



This is an example of one row of comma separated value data that I want to import into Excel 2013:

37950,004,08/21/2014 20:49:22,778052149 ,00310906021959200001

Column 1: ZIP Code (5-digit only)
Column 2: Date & Time (hh:mm:ss)
Column 3: ZIP+4+2 Code (11-digits; note last two digits are usually blank spaces in downloaded data)
Column 4: Tracking Number (20 digits)

How do I importing csv data to achieve the following:

Columns 1 should be ZIP Code (5-digit) formatted
Column 2 should be date formatted
Column 3 should be ZIP+4 (9-digit) formatted (ignore 2-digit blank spaces)
Column 4 should be numeric formatted data
Maintain all preceding zeros

I am currently getting:
(1) Dropped preceding zeros in all columns which I want to maintain
(2) Seconds in date/time dropped (but okay)
(3) Column 4 is main problem...imported data does not automatically format as numeric values and instead displays "3.10906E+17" (example)
(4) Column 4 certain values are zeros (not the value) For example, "200001" in example record at top of this message appears as "200000" and "200010" also appears as "200000"

How do I maintain preceding zeros?
What's happening to my last column values on importing?

Any help appreciated.

Keith