Excel Err Msg: Cannot Enter a Formula in Data FormLast reviewed: November 2, 1994Article ID: Q72106 |
SUMMARYWhen using a data form to enter information into a database in Excel for Windows, you may receive the error "Cannot Enter a Formula in Data Form" if you attempt to enter text that begins with a number (such as a phone number) when the Alternate Navigation Keys check box is selected. For example, if you choose Form from the Data menu and enter
(206)123-1234into any field, and Alternate Navigation Keys is selected, the error message occurs. To disable the Alternate Navigation Keys option:
REFERENCES"Microsoft Excel User's Guide," for Windows, version 3.0, pages 46-47, 356-365
|
KBCategory: kbother
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |