How do I import from csv file without auto formatting?
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.
|