Export to Excel and it does not reflect the orginal file

I am trying to convert a bank statement to Excel and the end result looks nothing like the original.  I then attempted to export it to Word and RTF thinking I could manipulate the data converting those files to Excel, but they still did not work.  Examples are 5's converting as S's and other characters that should be easy, but are converting as characters in different languages.  More that 50% of the file was wrong.  Is this something that can be avoided with some converting rules or should I seek a refund as I purchased it today and it has not worked as I thought it would?