Microsoft KB Archive/272871

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

Article ID: 272871

Article Last Modified on 1/29/2007

-

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.

Additional query words: off2001kb mac XL2001KB xl2001 alert error string length long text

Keywords: kbbug kbnofix KB272871

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.