View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
cincinnati kid cincinnati kid is offline
external usenet poster
 
Posts: 1
Default importing files from our mainframe into EXCEL

I have created a file from our mainframe with the ".xls" file extension. By
placing the hexidecimal value '05' between each field on my output file I was
able to cause the columns to be segarated properly.
My question is has anyone done this before? The biggest question is can I
somehow control the width of the cell and set all cells to "text". If I have
leading zeroes in my data EXCEL will suppress it.