Decimal/Currency Formatted Data Type Interpreted Incorrectly

• 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.

REFERENCES

"Q+E for Microsoft Excel User's Guide," version 3.0, pages 45-46