CSV loading incorrect

W

Washeacrim

When A CSV file is loaded into Excel 2003 it in a text format ie within in
the first column followed by commas.
How do it get CSVs to load so it nloads has a excel spreadsheet format ie in
individual columns
 
R

ryguy7272

Data > Import External Data > Import Data > then click on file.
Open > Delimited > Next > Comma > Next Finish > OK.

Regards,
Ryan---
 
D

David Biddulph

If it didn't treat the commas as delimiters, then I wonder whether the
Windows Regional Options (accessed via Control Panel) are specifying the
list separator as semi-colon, rather than comma?
 

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

Excel does not accept text format! 0
Data Import Question 0
Adding data to MS Access from csv file 0
Merging from an Excel file with graphics 1
Getting Radio Buttons to work, that are inserted via AutoText 0
Collating copier reports 0
Trying to create custom labels from an csv file + Need items numerically counted out 0
Need Help with Macro Security 1

Top