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

"Ash" wrote:

My office does a download from a mainframe application to get data into
Excel. The data is put into a tab delimited and this the file Excel reads
for the import/download.

Quite of bit of the data is financial data which contains leading zeroes.
Currently, to preserve the leading zeroes, we put an apostrophe at the front
of each field (in the tab delimited file, so this is how it opens in Excel).

Is there a way to send it the data to Excel all as text so that the leading
zeroes will be preserved without having to use an apostrophe?

Thanks for your thoughts/help/comments!
Ashley