View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default 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.