Hi Joel, Thank you kindly for your response.

Unfortunately, the data isn't pulled into Excel via the import tool. The
"coversion" from tab delimited to Excel happens behind the scenes and the
Excel version of the report is what's available for a user to open. Meaning,
after we send the report for download, the next option we have is to click a
web link that allows us to Open/Save the Excel version of the report. The
report that we open is the one that was read from Tab Delimited file and it
is already put into the columns it needs to be in, but with the leading
apostrophes.

I thought this issue might be resolved by having the default format set to
text instead of general, but I haven't found anyway to do that.

"Joel" wrote:

On the import menu after you select Delimited - Comma then press Next a
choose TEXT.