XL2001: Setting Text Length Validation Criteria Beyond the Maximum Value Allowed Returns Incorrect Error Message (272871)


The information in this article applies to:

  • Microsoft Excel 2001 for Mac
This article was previously published under Q272871

SYMPTOMS

When you set the text length data validation criteria for a cell as equal to a number larger than the maximum allowed by Excel, you receive the following incorrect error message
Negative values cannot be used for Text length conditions.
even though the number that you typed is not negative.

RESOLUTION

The error message is displayed because the text length criteria exceeds the maximum allowed by Excel, which is 2,147,483,647. Select a value that is equal to or less than 2,147,483,647.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

MORE INFORMATION

For more information about setting validation criteria for cells, follow these steps:
  1. On the Help menu, click Contents and Index, click Index, and then click V.
  2. Scroll down until you locate validate, and then click the arrow to the left to view a list of topics under the general topic.
  3. Click Specify the valid entries for cells.
If you cannot find the information that you want, ask the Office Assistant.

Modification Type:MajorLast Reviewed:9/11/2002
Keywords:kbbug KB272871
©2002 Microsoft Corporation. All rights reserved.