Importing downloads into Excel
We typically take a mainframe download (a txt file) and import it into Excel
for the purpose of doing some data comparisons (using Exact for example) and
doing some calculations with If functions.
Lately, I noticed that on some of the numerical fields, the last digit of
numeric data is sometimes changed to a letter (a, c, h, etc.). Not always.
I cant seem to discern a pattern to this, YET.
Is there someway to get Excel to correctly interpret this for me?
Thanks
Marsh
|