Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 ... |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 ... |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2000 problem copying drawingobjects between sheets | Excel Discussion (Misc queries) | |||
How do I create a List in Excel 2000 | Excel Worksheet Functions | |||
Upgrade from Excel 2000 to Excel 2003 without MS Office 2003? | Excel Discussion (Misc queries) | |||
Activate method of Worksheet class fails in Excel 2000 | Excel Discussion (Misc queries) | |||
Excel XP 2002 Vs. Excel 2000 | Excel Discussion (Misc queries) |