Microsoft KB Archive/86740

{| = Decimal/Currency Formatted Data Type Interpreted Incorrectly =
 * width="100%"|

Last reviewed: November 29, 1994

Article ID: Q86740 The information in this article applies to:
 * Microsoft Excel for Windows, version 4.0
 * Q+E version 3.0a

SUMMARY
When you open a Microsoft Excel version 4.0 worksheet in Q+E, when you open and the Microsoft Excel worksheet contains columns formatted in either the decimal or currency format, the data in these columns will appear in the date or time formats when you open them in Q+E.

WORKAROUNDS
To work around this problem, follow the appropriate procedure below.

  In Microsoft Excel, choose Save As from the File menu, and select the DBF file format. The file will be properly defined when you open it in Q+E. -or-   To convert the date field back into a decimal or currency field in Q+E: 1. Select the field heading of the field that is to be changed. 2. From the Layout menu, choose Define Field. 3. Select the desired Data Type, and choose the OK button. The field will be redefined in the proper format. 

MORE INFORMATION
When you open a Microsoft Excel file in Q+E, the program guesses at the field type based on the first record in the file. In this case, Q+E makes the incorrect choice.