Problem description:

Data export to MS Excel doesn't work -- prices of calls appears as a date etc. Excel 97 or Excel 2000.

Solution:

In the menu "Parameters" choose item "Setting". On the page "File types" is possible to configure the type of exported file, column separator and decimal separator. These items must be set due to language setting of Win NT and due to your local language.

Functioning combination for example are:

CZ locale
*.txt
decimal separator = čárka
column separator = tabulátor
CZ locale
*.csv
decimal separator = čárka
column separator = středník
EN locale
*.txt
decimal separator = point
column separator = tabulator
EN locale
*.csv
decimal separator = point
column separator = comma

Decimal separator should correspond to Locale setting, column separator should be the tabulator for text files; for *.csv files it should correspond to setting of "items separator" in Locale because *.csv is "comma-separated-value" file and that "comma" depends on Locale.

Further information:

--

Keywords:

FaxChange,Administration,fxcostm,excel

If there is something unclear, send us an email to development@datasys.cz.