The spreadsheet must be set to the proper format before data is put into the
spreadsheet so the leading zeroes are preserved or the import methods need to
be told to keep the zeroes (like the import tool). the question is what is
the behind the scene method. I know a number of ways that it can be done but
which one are they using and how easily can it be modified. Is it a Query,
or a macro. The server may be opening an instance of Excel and putting the
data into the spreadsheet?

"Ash" wrote:

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.