I would and it seems to me Excel used to bring up that wizard when I'd
done this kind of thing years ago but none of our pcs with excel open
that wizard. Double click a CSV file here and Excel springs up with
it's interpretation of what is in the file already loaded. It's Excel
2000 if that makes a difference.

BoniM wrote:
When in the third step of the Text Import Wizard, change all columns from
General to Text.

"cj" wrote:

Here is a sample line from the csv file I get

"2007-02-21 11:07:44.0","MCKINNEY","SC","1172084864684"

When I double click the file it is opened in Excel but it comes in
looking like

07:44.0 MCKINNEY SC 1.17208E+12

I want this data shown in excel exactly as it was read in. As you will
note all the "fields" in the csv line are in "s to denote they are text.
How can this be accomplished?

Thanks