Q+E: Large Values in Money Field in ExcelFile Are Blank

Last reviewed: September 12, 1996
Article ID: Q94645
The information in this article applies to:
  • Q+E for Microsoft Excel for Windows, versions 3.0 and 3.0a (This product is available with Microsoft Excel for Windows versions 3,0 and 4.0).
  • Q+E for Microsoft Excel, version 3.0 for OS/2 (This product is available with version 3.0 of Microsoft Excel for OS/2)

SUMMARY

In Q+E for Microsoft Excel, the Money data type used in the ExcelFile driver has a range of -5368709.11 to +5368709.09, with an accuracy of 1/100 (one one-hundredth) of a dollar. Any values that exceed these limits will appear blank in the query window.

In order to use values that are not within this range, you must change the field data type from Money to Float. With the Float data type you can use precision floating point values that can range from -1.00E50 to +1.00E50 (that is negative and positive 10 followed by 49 zeroes), with all decimal values included to the 15th decimal place.

MORE INFORMATION

The ExcelFile driver in Q+E was written with a special data type called Money. The Money data type is stored as a long integer, not as a floating point value. This Long Integer is then is displayed as if it were a 2 decimal place floating point calculation -- this limits the maximum and minimum values to the range specified above.

Note: The Money data type in the ExcelFile driver is different from the Money data type available on SQL Server. The SQL Server Money data type can contain dollar and cent values between +- 922,337,203,685,447.5807 with accuracy to 1/10,000 (one ten-thousandth) of a dollar.

REFERENCES

"Q+E for Microsoft Excel User's Guide," version. 4.0, pages 93 and 150


KBCategory: kbusage
KBSubcategory:

Additional reference words: 4.0 3.00 3.0



THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: September 12, 1996
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.