Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Opening .csv file in Excel2003 vs Excel2000
When my Colleague opens a csv file in Excel 2000, it opens fine, when I do
the same in 2003 all contents are in the first column. We both have Dutch as Location which I know is an issue due to the comma seperator etc. but why can she open it? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Opening .csv file in Excel2003 vs Excel2000
Maybe her Windows list separator matches the separator that's used in the file?
Open up the regional settings applet under control panel In winXP: windows start button|settings|control panel|regional and language options On the Regional Options tab click the Customize button On the numbers tab, check the list separator box. Make it match what's used in the CSV file. Be aware that this is a windows setting and can affect other programs. Holmark wrote: When my Colleague opens a csv file in Excel 2000, it opens fine, when I do the same in 2003 all contents are in the first column. We both have Dutch as Location which I know is an issue due to the comma seperator etc. but why can she open it? -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Opening .csv file in Excel2003 vs Excel2000
Dear Dave,
Her list seperator doesn't match the seperator in the file Her separator is ; and in the file it's , Also I've checked our settings in the regional settings - they are all the same. - Therefore it makes no sense that it workes with her...... "Dave Peterson" wrote: Maybe her Windows list separator matches the separator that's used in the file? Open up the regional settings applet under control panel In winXP: windows start button|settings|control panel|regional and language options On the Regional Options tab click the Customize button On the numbers tab, check the list separator box. Make it match what's used in the CSV file. Be aware that this is a windows setting and can affect other programs. Holmark wrote: When my Colleague opens a csv file in Excel 2000, it opens fine, when I do the same in 2003 all contents are in the first column. We both have Dutch as Location which I know is an issue due to the comma seperator etc. but why can she open it? -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Opening .csv file in Excel2003 vs Excel2000
In some versions of excel (xl2002+???), there's an option you can check:
Tools|Options|International tab Check the settings there. Holmark wrote: Dear Dave, Her list seperator doesn't match the seperator in the file Her separator is ; and in the file it's , Also I've checked our settings in the regional settings - they are all the same. - Therefore it makes no sense that it workes with her...... "Dave Peterson" wrote: Maybe her Windows list separator matches the separator that's used in the file? Open up the regional settings applet under control panel In winXP: windows start button|settings|control panel|regional and language options On the Regional Options tab click the Customize button On the numbers tab, check the list separator box. Make it match what's used in the CSV file. Be aware that this is a windows setting and can affect other programs. Holmark wrote: When my Colleague opens a csv file in Excel 2000, it opens fine, when I do the same in 2003 all contents are in the first column. We both have Dutch as Location which I know is an issue due to the comma seperator etc. but why can she open it? -- Dave Peterson -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Opening .csv file in Excel2003 vs Excel2000
I've checked this in my version and it is set to use system settings but as
my colleauge runs version 2000 this option is not available..... "Dave Peterson" wrote: In some versions of excel (xl2002+???), there's an option you can check: Tools|Options|International tab Check the settings there. Holmark wrote: Dear Dave, Her list seperator doesn't match the seperator in the file Her separator is ; and in the file it's , Also I've checked our settings in the regional settings - they are all the same. - Therefore it makes no sense that it workes with her...... "Dave Peterson" wrote: Maybe her Windows list separator matches the separator that's used in the file? Open up the regional settings applet under control panel In winXP: windows start button|settings|control panel|regional and language options On the Regional Options tab click the Customize button On the numbers tab, check the list separator box. Make it match what's used in the CSV file. Be aware that this is a windows setting and can affect other programs. Holmark wrote: When my Colleague opens a csv file in Excel 2000, it opens fine, when I do the same in 2003 all contents are in the first column. We both have Dutch as Location which I know is an issue due to the comma seperator etc. but why can she open it? -- Dave Peterson -- Dave Peterson |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Opening .csv file in Excel2003 vs Excel2000
Although it sounds backwards to me, maybe you could try matching her settings
(sounds very silly to me, but it won't take long to test it). And how do each of you open the file? (doubleclicking on it in windows explorer or file|open or by a macro???). Holmark wrote: I've checked this in my version and it is set to use system settings but as my colleauge runs version 2000 this option is not available..... "Dave Peterson" wrote: In some versions of excel (xl2002+???), there's an option you can check: Tools|Options|International tab Check the settings there. Holmark wrote: Dear Dave, Her list seperator doesn't match the seperator in the file Her separator is ; and in the file it's , Also I've checked our settings in the regional settings - they are all the same. - Therefore it makes no sense that it workes with her...... "Dave Peterson" wrote: Maybe her Windows list separator matches the separator that's used in the file? Open up the regional settings applet under control panel In winXP: windows start button|settings|control panel|regional and language options On the Regional Options tab click the Customize button On the numbers tab, check the list separator box. Make it match what's used in the CSV file. Be aware that this is a windows setting and can affect other programs. Holmark wrote: When my Colleague opens a csv file in Excel 2000, it opens fine, when I do the same in 2003 all contents are in the first column. We both have Dutch as Location which I know is an issue due to the comma seperator etc. but why can she open it? -- Dave Peterson -- Dave Peterson -- Dave Peterson |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Opening .csv file in Excel2003 vs Excel2000
The only place I can match her settings is in the regional settings and they
are the same. Also it doesn't matter how we open the file (doubleclicking or via file open from within Excel) the result is the same... It is not logical that it works for her as there is an issue with the Dutch regional settings (decimal symbol is an comma) but if only I could figure out why it does work I might be able to solve the problem within 2003 as well. Thanks you for your help.... "Dave Peterson" wrote: Although it sounds backwards to me, maybe you could try matching her settings (sounds very silly to me, but it won't take long to test it). And how do each of you open the file? (doubleclicking on it in windows explorer or file|open or by a macro???). Holmark wrote: I've checked this in my version and it is set to use system settings but as my colleauge runs version 2000 this option is not available..... "Dave Peterson" wrote: In some versions of excel (xl2002+???), there's an option you can check: Tools|Options|International tab Check the settings there. Holmark wrote: Dear Dave, Her list seperator doesn't match the seperator in the file Her separator is ; and in the file it's , Also I've checked our settings in the regional settings - they are all the same. - Therefore it makes no sense that it workes with her...... "Dave Peterson" wrote: Maybe her Windows list separator matches the separator that's used in the file? Open up the regional settings applet under control panel In winXP: windows start button|settings|control panel|regional and language options On the Regional Options tab click the Customize button On the numbers tab, check the list separator box. Make it match what's used in the CSV file. Be aware that this is a windows setting and can affect other programs. Holmark wrote: When my Colleague opens a csv file in Excel 2000, it opens fine, when I do the same in 2003 all contents are in the first column. We both have Dutch as Location which I know is an issue due to the comma seperator etc. but why can she open it? -- Dave Peterson -- Dave Peterson -- Dave Peterson |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Opening .csv file in Excel2003 vs Excel2000
How about change the .csv to .txt and try opening it that way..
Holmark wrote: The only place I can match her settings is in the regional settings and they are the same. Also it doesn't matter how we open the file (doubleclicking or via file open from within Excel) the result is the same... It is not logical that it works for her as there is an issue with the Dutch regional settings (decimal symbol is an comma) but if only I could figure out why it does work I might be able to solve the problem within 2003 as well. Thanks you for your help.... "Dave Peterson" wrote: Although it sounds backwards to me, maybe you could try matching her settings (sounds very silly to me, but it won't take long to test it). And how do each of you open the file? (doubleclicking on it in windows explorer or file|open or by a macro???). Holmark wrote: I've checked this in my version and it is set to use system settings but as my colleauge runs version 2000 this option is not available..... "Dave Peterson" wrote: In some versions of excel (xl2002+???), there's an option you can check: Tools|Options|International tab Check the settings there. Holmark wrote: Dear Dave, Her list seperator doesn't match the seperator in the file Her separator is ; and in the file it's , Also I've checked our settings in the regional settings - they are all the same. - Therefore it makes no sense that it workes with her...... "Dave Peterson" wrote: Maybe her Windows list separator matches the separator that's used in the file? Open up the regional settings applet under control panel In winXP: windows start button|settings|control panel|regional and language options On the Regional Options tab click the Customize button On the numbers tab, check the list separator box. Make it match what's used in the CSV file. Be aware that this is a windows setting and can affect other programs. Holmark wrote: When my Colleague opens a csv file in Excel 2000, it opens fine, when I do the same in 2003 all contents are in the first column. We both have Dutch as Location which I know is an issue due to the comma seperator etc. but why can she open it? -- Dave Peterson -- Dave Peterson -- Dave Peterson |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Opening .csv file in Excel2003 vs Excel2000
Thanks Bob for the surgestion, but I have enough work arounds. I'm just
puzzeled by the fact that it works for her and not others. "Bob I" wrote: How about change the .csv to .txt and try opening it that way.. Holmark wrote: The only place I can match her settings is in the regional settings and they are the same. Also it doesn't matter how we open the file (doubleclicking or via file open from within Excel) the result is the same... It is not logical that it works for her as there is an issue with the Dutch regional settings (decimal symbol is an comma) but if only I could figure out why it does work I might be able to solve the problem within 2003 as well. Thanks you for your help.... "Dave Peterson" wrote: Although it sounds backwards to me, maybe you could try matching her settings (sounds very silly to me, but it won't take long to test it). And how do each of you open the file? (doubleclicking on it in windows explorer or file|open or by a macro???). Holmark wrote: I've checked this in my version and it is set to use system settings but as my colleauge runs version 2000 this option is not available..... "Dave Peterson" wrote: In some versions of excel (xl2002+???), there's an option you can check: Tools|Options|International tab Check the settings there. Holmark wrote: Dear Dave, Her list seperator doesn't match the seperator in the file Her separator is ; and in the file it's , Also I've checked our settings in the regional settings - they are all the same. - Therefore it makes no sense that it workes with her...... "Dave Peterson" wrote: Maybe her Windows list separator matches the separator that's used in the file? Open up the regional settings applet under control panel In winXP: windows start button|settings|control panel|regional and language options On the Regional Options tab click the Customize button On the numbers tab, check the list separator box. Make it match what's used in the CSV file. Be aware that this is a windows setting and can affect other programs. Holmark wrote: When my Colleague opens a csv file in Excel 2000, it opens fine, when I do the same in 2003 all contents are in the first column. We both have Dutch as Location which I know is an issue due to the comma seperator etc. but why can she open it? -- Dave Peterson -- Dave Peterson -- Dave Peterson |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
Opening .csv file in Excel2003 vs Excel2000
I suspect the reason revolves around the language settings and default
handling of the value separator when CSV is the extension. IF you change it to a TXT extension, you MUST tell it what the seperator is and then you may find out why the two are different. Holmark wrote: Thanks Bob for the surgestion, but I have enough work arounds. I'm just puzzeled by the fact that it works for her and not others. "Bob I" wrote: How about change the .csv to .txt and try opening it that way.. Holmark wrote: The only place I can match her settings is in the regional settings and they are the same. Also it doesn't matter how we open the file (doubleclicking or via file open from within Excel) the result is the same... It is not logical that it works for her as there is an issue with the Dutch regional settings (decimal symbol is an comma) but if only I could figure out why it does work I might be able to solve the problem within 2003 as well. Thanks you for your help.... "Dave Peterson" wrote: Although it sounds backwards to me, maybe you could try matching her settings (sounds very silly to me, but it won't take long to test it). And how do each of you open the file? (doubleclicking on it in windows explorer or file|open or by a macro???). Holmark wrote: I've checked this in my version and it is set to use system settings but as my colleauge runs version 2000 this option is not available..... "Dave Peterson" wrote: In some versions of excel (xl2002+???), there's an option you can check: Tools|Options|International tab Check the settings there. Holmark wrote: Dear Dave, Her list seperator doesn't match the seperator in the file Her separator is ; and in the file it's , Also I've checked our settings in the regional settings - they are all the same. - Therefore it makes no sense that it workes with her...... "Dave Peterson" wrote: Maybe her Windows list separator matches the separator that's used in the file? Open up the regional settings applet under control panel In winXP: windows start button|settings|control panel|regional and language options On the Regional Options tab click the Customize button On the numbers tab, check the list separator box. Make it match what's used in the CSV file. Be aware that this is a windows setting and can affect other programs. Holmark wrote: When my Colleague opens a csv file in Excel 2000, it opens fine, when I do the same in 2003 all contents are in the first column. We both have Dutch as Location which I know is an issue due to the comma seperator etc. but why can she open it? -- Dave Peterson -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
File:1 and File:2 -- Double Files when Opening One File | Excel Discussion (Misc queries) | |||
How can I use autosave from excel2000 in excel2003 | Excel Worksheet Functions | |||
opening an excel file opens a duplicate file of the same file | Excel Discussion (Misc queries) | |||
In EXCEL2000, How can I copy a file and make it usable in MS WORK | Excel Discussion (Misc queries) | |||
excel2000 owc doesn't work on excel2003 ! | Excel Discussion (Misc queries) |