Solved

IMPORTING DATA IN EXCEL 2003 PROFESSIONAL IMPROPERLY DISPLAYS DATA IN GENERAL OR TEXT AS FORMULATED

Posted on 2011-02-17
4
269 Views
Last Modified: 2012-05-11
I have a text file that I am exporting from a Unix system to an ASCII text file and then opening the file or importing the text in an excel document and for some reason all my order numbers are coming up as dates. Some of them are accurate, but then it switches to date format. I have tried to export the data from Unix in CSV format and it does not matter how I do this, I still can not get the excel spreadsheet to display the cells accurately. I even tried to format the cells before I imported the data in the cell. I can't for the life of me figure out how to get this data to display accurately.
0
Comment
Question by:SLGREZEL
4 Comments
 
LVL 5

Expert Comment

by:skrga
ID: 34920352
Can you post that ASCII text file ?
0
 
LVL 6

Expert Comment

by:bluepig
ID: 34920502
You may have to use the import wizard, and possibly create an import template to speed up the process next time. From the help file:

If the file is a text file (.txt), Excel starts the Import Text Wizard.
Follow the instructions in the Text Import Wizard. Click Help  for more information about using the Text Import Wizard or see Text Import Wizard. When you are done with the steps in the wizard, click Finish to complete the import operation.

If the file is a .csv file, Excel automatically opens the text file and displays the data in a new workbook.
 Note    When Excel opens a .csv file, it uses the current default data format settings to interpret how to import each column of data. If you want more flexibility in converting columns to different data formats, you can use the Import Text Wizard. For example, the format of a data column in the .csv file may be MDY, but Excel's default data format is YMD, or you want to convert a column of numbers that contains leading zeros to text so you can preserve the leading zeros. To run the Import Text Wizard, you can change the file name extension from .csv to .txt before you open it, or you can Import a text file by connecting to it.
0
 
LVL 18

Accepted Solution

by:
Richard Daneke earned 500 total points
ID: 34922295
As you import/convert a text file to Excel, the questions for each column(cell) are presented on one (JUST ONE) of the pages of this wizard.
You can select the column with your mouse, above the work area are radio control buttons to declare this data as General, Text, Number, Date (and format), and even a Do Not Import.
Please take a minute to select the correct value here.
0
 

Author Closing Comment

by:SLGREZEL
ID: 34926815
Thank you I was able to change the column that was having issues to text and that worked. For some reason when the columns originally come thru they come thru in general format which causes the issue. All set
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Improved? Move/Copy Add-in Replacement - How to avoid the annoying, “A formula or sheet you want to move or copy contains the name XXX, which already exists on the destination worksheet.” David Miller (dlmille)  It was one of those days… I wa…
How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now