IMPORTING DATA IN EXCEL 2003 PROFESSIONAL IMPROPERLY DISPLAYS DATA IN GENERAL OR TEXT AS FORMULATED
Posted on 2011-02-17
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.