Home |
Search |
Today's Posts |
#1
|
|||
|
|||
opening csv file in regular excel format
i am using office 2003. i used to download csv files and open in regular excel formats...due to some problem i reinstalled windows xp and office 2003...now my csv files open with all values separated by commas and not as before...
sould anyone highlight how to download csv files automatically in excel formats withouts commas? suresh babu,chennai,india |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
opening csv file in regular excel format
If the data has commas between each field and you want each field in a separate
column, you'll have to make sure that your windows list separator is a comma. (Many places, this list separator is a semicolon.) windows control panel Regional and Language Options Regional options tab click the Customize button Numbers Tab change that list separator character. Remember that this is a windows setting. It will affect other programs, too. (You may want to change it back when you're done importing the data.) sureshbabussb wrote: i am using office 2003. i used to download csv files and open in regular excel formats...due to some problem i reinstalled windows xp and office 2003...now my csv files open with all values separated by commas and not as before... sould anyone highlight how to download csv files automatically in excel formats withouts commas? suresh babu,chennai,india -- sureshbabussb -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"Unable to read file" error message when opening a Excel file that contains a PivotTable report. | Charts and Charting in Excel | |||
Opening and file associations for Excel | Excel Discussion (Misc queries) | |||
Excel 2003 to 95 File format conversion | Excel Discussion (Misc queries) | |||
Trouble opening an Excel file that contains macros | Excel Worksheet Functions | |||
error opening excel file | Excel Discussion (Misc queries) |