How do I import from csv file without auto formatting?
 

I want to import a csv file into Excel without having Excel automatically
formatting the values.

How do I import from csv file without auto formatting?
 

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.

How do I import from csv file without auto formatting?
 

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.

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.

How do I import from csv file without auto formatting?
 

Maybe you could use:
Data|Import external data|
(in xl2003 menus)

zvikam wrote:

I want to import a csv file into Excel without having Excel automatically
formatting the values.

--

Dave Peterson

How do I import from csv file without auto formatting?
 

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.