coma not separating data

M

moinik123

On my frend's machine coma is separating data in differentes colonnes.
But my Excel put all data in one colonne.

The same file is used.

Thank you.
 
D

Dave Peterson

I'd look at the windows setting that controls the list separator.

windows start button|settings|control panel|Regional settings applet
(or regional and language options)

Click the customize button
Numbers Tab
List separator

Make sure it matches the separator in the data (a comma).
 
W

wjohnson

Are you Copying and Pasteing?
or Are You doing a "FILE OPEN?"
If you are doing a File Open then EXCEL should interpert the file as
comma separated values, (CSV) and put stuff into different columns.
Copy and paste - everything will go into one column.
But you can also do the following:
Once you have imported the DATA into your EXCEL file - select the
column - then on the MENU Bar - Select - DATA-TEXT TO COLUMNS and
follow the directions.
 
M

moinik123

WORKING!!!

Thank's a lot.


Dave said:
I'd look at the windows setting that controls the list separator.

windows start button|settings|control panel|Regional settings applet
(or regional and language options)

Click the customize button
Numbers Tab
List separator

Make sure it matches the separator in the data (a comma).

Dave Peterson
Click to expand...
 
Top