excel 2000 takes comma as period

[Guest]

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

 

[Alan]

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

 

[Harald Staff]

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

Best wishes Harald

 

[Guest]

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.

 

[Guest]

Could anyone give me some hints? many thanks.