I'm using Micorsoft 2007 and trying to open a file with a .PRN extension. This is a comma-delimited file and created several years ago from our legacy system. In the past, I would open the files using the Wizard and I would open it as a comma-delimited file in Excel. The file today only opens in Wordpad of Notepad. I must have it open in Microsoft EXCEL 2007. Any ideas?
That is not a comma deliminated file but a print file. You could go copy filename lpt1 to print it. You may want to associate the prn extension with excel or do a right mouse click and open with choosing excel.
Moderator please move to Office forum where you may get a better answer
Answers are only as good as the information you provide.
How to properly post a question:
.PRN is interpreted as blank delimited columns. Start excel and import thr file as space delimited. I hate the ribbon interface of Office 2007, but I am sure the command exist as there is in Excel 2003 under Data menu.
save the .prn file to your desktop. Before opening, change the extension to .xls. The file can be delimited in Excel.
In Windows 7, I have .prn associated with Excel, but it still does not open immediately. I have to change the extension first to .xls & then it open.
So far this is the only way Ive been able to open this file in Windows 7.
Ad Choices