Excel to show cvs file

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hi.
In my home PC, when i do download an exle (comma separated file CVS file)
all data coming in frist columns only(column A).
but when i download the same file at my office PC, Excle open it as i
want(in all coloumns Not only in column A).
How can i fix my home PC to do as my office PC.?
thanks
Mike
 
My first guess is that your pc at work and your pc at home have a different
windows list separator.

I'd close excel
windows start button|settings|control panel|regional and language options
(or regional settings)
Then customize button (winXP)
then Numbers tab
look at the list separator.

Most USA users use a comma.
Others use a semicolon.
 
Back
Top