View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Marsh Marsh is offline
external usenet poster
 
Posts: 37
Default 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