Z
zvikam
I want to import a csv file into Excel without having Excel automatically
formatting the values.
formatting the values.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
David Biddulph
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.
Data/ Import External Data. Then choose appropriate format (probably text)
for each column.
Z
zvikam
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.
as text without the need to configure this setting through this wizard each
time.
Thanks,
Zvika.
D
David Biddulph
Change the extension of your csv files to .txt.
D
Dave Peterson
Maybe you could use:
Data|Import external data|
(in xl2003 menus)
Data|Import external data|
(in xl2003 menus)
Z
zvikam
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.
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.