![]() |
CSV loading incorrect
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 |
CSV loading incorrect
Data Import External Data Import Data then click on file.
Open Delimited Next Comma Next Finish OK. Regards, Ryan--- -- RyGuy "Washeacrim" wrote: 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 |
CSV loading incorrect
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? -- David Biddulph "ryguy7272" wrote in message ... Data Import External Data Import Data then click on file. Open Delimited Next Comma Next Finish OK. Regards, Ryan--- -- RyGuy "Washeacrim" wrote: 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 |
All times are GMT +1. The time now is 09:54 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com