I have a customer who sends a proprietary file to me at Timex Corp. The data
is from an old system. When loaded into excel, there is an alpha code or a
special character in the low order units position of the fields. This
indicates whether the amount is positive or negative. For instance, 0006688B
is the value sent. The "B" is a numeric field with an over punch.

How do I tell excel to disregard the over punch so that the "B" converts to
a valid numeric digit?

Thanks for your assistance with this question.

Regards, Lou Nugai
Sr. EDI Analyst
Timex Corporation.