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 |
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) |