Microsoft KB Archive/61489

{|
 * width="100%"|

Excel: Database Functions Return Incorrect Results, Errors

 * }

-

The information in this article applies to:


 * Microsoft Excel for the Macintosh, versions 1.x, 2.2, 3.0, 4.0

-

SYMPTOMS
In Microsoft Excel for the Macintosh, when a field name in a database is entered as a number or date, any type of function using the criteria will not work correctly.

A data form will display field names that are dates as their serial number equivalents. For example, if the date &quot;8/1/90&quot; is a field name, the data form will display it as &quot;31624&quot; (the serial number for 8/1/90). This cannot be reformatted.

When attempting to extract data into a range containing number or date field names, the error message &quot;Extract range is not valid&quot; will appear.

WORKAROUND
To correct these problems, change the field name to a text string. A text string can be a combination of alpha and numeric characters.

Additional query words: 1.0 1.00 1.03 1.04 1.06 1.5 1.50 2.20 3.0 4.00

Keywords :

Version :

Platform :

Issue type :

Technology :