Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Loading... | Excel Discussion (Misc queries) | |||
loading | Excel Discussion (Misc queries) | |||
Tool bar keeps loading | Excel Discussion (Misc queries) | |||
Loading Pages | Excel Discussion (Misc queries) | |||
Add-ins not loading | Excel Discussion (Misc queries) |