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