DAVION

SYSTEMS

International Numeric Formats

 

When you import a price list from an external supplier, it is possible that the supplier has combined unit prices with quantity units, e.g. $5.83 each, or $150/ton. Mandrel has to extract the numeric values from these entries. In addition, if the supplier is from another country there may be currency symbols that your computer does not recognize. To deal with these problems, Mandrel scans unit prices character by character and extracts only the numeric symbols.

 

Extracting price values in this way raises another problem:  there are different conventions in use around the world for writing numbers. These are summarized in the table below.

 

Thousands Separator

Decimal Separator

Example

Typical Areas of Use

Comma

Period

1,234,567.89

English-speaking world

Space

Comma

1 234 567,89

Most of the rest of the world

Period

Comma

1.234.567,89

Largely obsolete, but sometimes used in Italy

 

When you import a price list, you have to tell Mandrel which numeric format is in use.