ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   Excel to show cvs file (https://www.excelbanter.com/setting-up-configuration-excel/22316-excel-show-cvs-file.html)

Mike21

Excel to show cvs file
 
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

Dave Peterson

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.

Mike21 wrote:

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


--

Dave Peterson


All times are GMT +1. The time now is 10:26 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com