Conversion routines in interfaces will therefore not be simple, and complex rounding error handling will be required . 4.10 Special care will be required to avoid inadvertently mixing sterling and euro data. If historical data is converted to euro, the considerations on vertical rounding errors above will be relevant. Due to the need to round to the nearest euro cent, financial fields may lack decimal places which are required on conversion to euro. Since the euro will have a lower unit value than sterling, maximum values will be significantly bigger.
Truncation is unacceptable under any circumstances.
Therefore field sizes must be reviewed to ensure they are big enough. Thresholds 4.14 Rounding errors can affect the conversion of threshold values and ranges such that some values are excluded. For example in the following table, the values EUR 1528.30, EUR 6133.18 and EUR 12226.35 are undefined. The European Commission advises replacing rather than converting spreadsheets because of the complexity of conversion, see European Commission DG XV, Preparing Financial Information Systems for the Euro . The information on the site is the property of the Association of British Insurers.