Excel 2007 Import Issue

  • Thread starter Thread starter bjr
  • Start date Start date
B

bjr

I have an *.csv file and want to open the file in Excel. Some of the
data is large number and other lines have text that include + and minus
signs.

When the file is opened in Excel, the some data has exponents (large
number) and the direction data is interpreted as a formula.

How can I get the data to just show as it is typed, i.e. text data.

Here is the file in Notepad:
98765430123456789,xyz
9876543A123456789,+xyz
9876543B123456789,-xyz
9876543C123456789,xyz
Here is the Excel after opening the file:
9.87654E+16 xyz
9876543A123456789 #NAME?
9876543B123456789 #NAME?
9876543C123456789 xyz
 
Attempting to import a text file into excel.
I am trying to import the Exchange SMTP Service logs into Excel 2007 and I
get the problem found and Excel restarts everytime.

The same file imports into Excel 2003 with No problems.

A sample line from the file:
2007-02-26 05:02:49 62.108.196.167 mx3.mailserver.org SMTPSVC1 SERVERNAME
192.168.1.1 MAIL - +FROM:<[email protected]> 250 54 41 0 SMTP - - - -
 
I would change the .csv extension to .txt and open that and let the Text Import
Wizard look after the data.

Delimited by comma>next>column data format>text for both columns.


Gord Dibben MS Excel MVP
 
Try renaming the file to *.txt.

Then when you do File|Open, you'll see the text to columns wizard pop up. You
can specify text for both of these fields.

Excel only keeps track of 15 significant digits, treating the first field as
text and you won't lose anything for that first entry.

Treating the second field as text means that +xyz won't look like a formula
(trying to add the defined name xyz).
 
Back
Top