excel 2000 takes comma as period
 

Hi all,

In text files, tab is used as column separator and comma is used as decimal
point. Numbers are like 1,4451, 0,8, etc. The OS is windows 2000 and office
version is 2000. Regional was set to Dutch(Belgium). When i double click one
file, the file was opened in excel but with wrong data. 1,4451 is shown as
14,451 in cell. And its real value is changed to 14551 by excel.
However, if i use import feature to open the file, every thing is okay. Why
excel does not use system's regional setting to open a text file?

Thanks

excel 2000 takes comma as period
 

Within Excel check the setting under <Tools<Options<International
from the menu ...


aurorean wrote:
Hi all,

In text files, tab is used as column separator and comma is used as decimal
point. Numbers are like 1,4451, 0,8, etc. The OS is windows 2000 and office
version is 2000. Regional was set to Dutch(Belgium). When i double click one
file, the file was opened in excel but with wrong data. 1,4451 is shown as
14,451 in cell. And its real value is changed to 14551 by excel.
However, if i use import feature to open the file, every thing is okay. Why
excel does not use system's regional setting to open a text file?

Thanks

excel 2000 takes comma as period
 

The Internatiopnal option was introduced with Excel XP (2002).

Best wishes Harald

"Alan" skrev i melding
oups.com...
Within Excel check the setting under <Tools<Options<International
from the menu ...

excel 2000 takes comma as period
 

correct. under version 2002, there is no "international" option in Excel.

The wired thing is that the data is wrong via double-clicking to open the
file, but data is correct via "File-Open-import wizard" to open the file.
These two phenomena happened on client's machine concurrently. I tried to
reproduce the problem on many machines with same OS and office version, but
unlucky.

"Harald Staff" wrote:

The Internatiopnal option was introduced with Excel XP (2002).

Best wishes Harald

"Alan" skrev i melding
oups.com...
Within Excel check the setting under <Tools<Options<International
from the menu ...

excel 2000 takes comma as period
 

Could anyone give me some hints? many thanks.

"aurorean" wrote:

Hi all,

In text files, tab is used as column separator and comma is used as decimal
point. Numbers are like 1,4451, 0,8, etc. The OS is windows 2000 and office
version is 2000. Regional was set to Dutch(Belgium). When i double click one
file, the file was opened in excel but with wrong data. 1,4451 is shown as
14,451 in cell. And its real value is changed to 14551 by excel.
However, if i use import feature to open the file, every thing is okay. Why
excel does not use system's regional setting to open a text file?

Thanks