>>I have a CSV file. In this file the account number (which is supposed to be a character field) doesn't have quotes around it. Excel treats this column as a general format. I want this column to be treated as a text.
>
>Then apply formatting to appropriate columns, like:
>
>oExcel.Activesheet.UsedRange.NumberFormat = "@"

Thanks, I'll try that.