I'm attempting to open and format a large (2400 columns) pipe-delimited .txt file using VBA. I'm specifying six columns to be formatted as text, since they contain large numbers that would otherwise show up with scientific notation. I've done this kind of thing numerous times, but in this case, it is applying the text formatting to the first six columns instead of to the column numbers I'm specifying. Am I missing something, or is there a problem with importing a file with so many columns?

    Workbooks.OpenText Filename:=Folder & DataBook, _
        StartRow:=1, DataType:=xlDelimited, TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False, Other:=True, OtherChar:="|", _
        FieldInfo:=Array(Array(83, 2), Array(172, 2), Array(425, 2), Array(1241, 2), Array(1466, 2), Array(1570, 2))