Solved

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

Posted on 2011-02-17
4
278 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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 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

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

Suggested Solutions

Title # Comments Views Activity
have to show the rows i need 9 37
VBA routine modification/tweak needed 10 51
autofill formulas using macro 8 48
Combining match and vlookup??? 4 23
This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

738 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