Excel: Database Functions Return Incorrect Results, ErrorsLast reviewed: November 29, 1994Article ID: Q61489 |
The information in this article applies to:
SYMPTOMSIn 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 "8/1/90" is a field name, the data form will display it as "31624" (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 "Extract range is not valid" will appear.
WORKAROUNDTo correct these problems, change the field name to a text string. A text string can be a combination of alpha and numeric characters.
|
KBCategory: kbusage
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |