Microsoft KB Archive/212013

= XL2000: Calculation of Formula in Formula Bar Returns #VALUE! =

Article ID: 212013

Article Last Modified on 10/8/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q212013





SYMPTOMS
In Microsoft Excel 2000, when you press F9 to evaluate a formula in the formula bar, the formula may return #VALUE! even when the formula returns the correct result to the cell.



CAUSE
This behavior occurs if the formula returns a string that contains more than 255 characters.



MORE INFORMATION
In Microsoft Excel, you can select all or part of a formula in the formula bar and press F9 to evaluate only the selected portion. If the selected portion returns a string that contains greater than 255 characters, it returns #VALUE!.

For example, if you type the following formula in a cell

=REPT("a",1000)

and you select the formula in the formula bar and press F9, the formula returns #VALUE! instead of a string that contains 1000 "a" characters as expected.

The following text functions may evaluate to #VALUE! if they return more than 255 characters:   CLEAN CONCATENATE LEFT LOWER MID PROPER REPLACE REPT RIGHT SUBSTITUTE TRIM UPPER

Additional query words: string function recalculate calculate XL2000

Keywords: kbprb KB212013

-

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

© Microsoft Corporation. All rights reserved.