Hmmm, doesn't seem to work.
If it's comma separated, once I open it in Excel, it puts the entire row in
one cell as one big string. If it's tab separated, it does the same auto
formatting.
Sad.

"David Biddulph" wrote:

Change the extension of your csv files to .txt.
--
David Biddulph

"zvikam" wrote in message
...
Can I automate this? I want it always to open csv files treating all
values
as text without the need to configure this setting through this wizard
each
time.

Thanks,
Zvika.

"David Biddulph" wrote:

Read it in not by double clicking or by File/ Open, but instead use
Excel's
Data/ Import External Data. Then choose appropriate format (probably
text)
for each column.
--
David Biddulph

"zvikam" wrote in message
...
I want to import a csv file into Excel without having Excel
automatically
formatting the values.