Application Specific Problems

Last 2 Digits Changed in Large Decimal Values

When numeric values are retrieved from a database, Windows platforms convert binary-coded decimal notation (BCD) to double-type format. In BCD notation, one byte of information can store two, decimal digits. There is no limitation on the number of bytes which may be stored. However, Windows--and Excel, by extension--can only support double-number format. This format stores up to eight bytes of information. Therefore, large numeric values are truncated.