?
Solved

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

Posted on 2011-02-17
4
Medium Priority
?
290 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 19

Accepted Solution

by:
Richard Daneke earned 2000 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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

This article describes a serious pitfall that can happen when deleting shapes using VBA.
This article describes how you can use Custom Document Properties to store settings and other information in your workbook so that they will be available the next time you open the workbook.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

862 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