How do I import from csv file without auto formatting?

Z

zvikam

I want to import a csv file into Excel without having Excel automatically
formatting the values.
 
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.
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Import Multiple CSV Files from Same Folder into Open Workbook 5
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Excel CSV Files; Creating Of 3
Excel And Notepad 3
CSV->Excel Data Problem 1
csv, how to set excel to auto load 5
How to save files in the formats of *.csv(MS-DOS) in Excel 2003 2
Import more than one .csv file into the same Excel file. 1

Top