Importing tab delimited file into excel

[Denise]

I am importing a tab delimited file into excel. I need to
create a spreadsheet automatically without intervension or
formating fields in spreadsheet. My problems are:

1) I have a field 007 - when importing it defaults to 7
instead of 007.
2) I have an amount 55.50 - imports as 55.5 or 76.00
imports as 76 I need the 2 decimal points to display
3) I have a number which imports as 1.2E+08, I need this
to automatically be a valued number.

This spreadsheet will automatically be send to another
application for importing into their system without
manually intervension.

Any suggestions?

 

[Sean Flanagan]

I suggest you create a template with formatting that
permits your imported data to display as you expect. For
example, format the columns that you want to display as
76.00 as Numeric, 2 decimal places. Format the width of
columns that display numbers in Scientific Notation to be
wide enough to show the number properly at the default
font size. Then, when you perform your import, pick your
new template to send the import to.

HTH,
-Sean-