Oct 15, 2006, 11:58 AM
|
#1 of 3
|
Well... this is interesting. I'm not able to open .PRN files but I checked the extension and found out I can open the files in a text editor. I opened this file in a text editor and at a glance it looked tab-delimited to me... but it really wasn't.
I renamed the file from MALE89.PRN to MALE89.TXT.
Started up excel.
File Open >> Choose text file from drop down >> select MALE89.TXT
Choose Fixed width format in the next dialog box. Excel figures out the columns for you. Hit Finish. Data is there. I don't know if this will work for you or not... but I managed to get some sort of data from that file you sent.
XLS file is attached.
What you might want to do with your original XLS file is to save it as a CSV or even TXT file and try reimporting it the way I listed above.
Most amazing jew boots
|