Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,836
Default 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

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,651
Default 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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Loading... K Excel Discussion (Misc queries) 1 October 7th 07 09:37 PM
loading mallahd Excel Discussion (Misc queries) 2 May 25th 07 07:59 PM
Tool bar keeps loading noyb Excel Discussion (Misc queries) 1 August 3rd 06 06:47 PM
Loading Pages Mindie Excel Discussion (Misc queries) 5 April 5th 05 07:25 PM
Add-ins not loading John F Excel Discussion (Misc queries) 2 February 17th 05 08:54 PM


All times are GMT +1. The time now is 02:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"