Another option is to open a blank excel sheet. Go to Data Import
External Data, Import Data. Then choose the file. Once it opens the
file in the wizard, you can use the formating option per cell to format
the cells before importing. This was Excel does not mess with the
data/change the data.

I also run into this issue where Excel likes to change certain things
to dates, Scientific, or whatever and screw up the info, so formatting
as text solves this problem as Excel will import it as text and not
mess with the original formatting.

Just a thought.


--
confuzedagain
------------------------------------------------------------------------
confuzedagain's Profile: http://www.excelforum.com/member.php...o&userid=29439
View this thread: http://www.excelforum.com/showthread...hreadid=491323