MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Importing PRN file into Excel. Not recognizing negatives.

Posted by Doug on October 05, 2000 7:44 AM

I have a legacy system with some accounting information I want to import into Excel. The problem is that in the legacy system, negative numbers are expressed with the dash at the end of the number i.e. $4,545.23-. When I import a PRN file into excel and make the proper column breaks, Excel treats all the negative numbers as labels. Any ideas?

I can manually edit each cell, moving the negative from the back to the front. It works, but I'm looking for a quicker method.

Thanks all you brains out there!!!!

Posted by Celia on October 06, 2000 3:23 AM

Have a look at DashMasher_VBA.xls at :-
(broken link)

Posted by Doug Bernart on October 06, 2000 11:37 AM

!!!! Celia, you are awesome. It worked perfectly. I wish I could give you a cyber-hug!!!!!