Microsoft KB Archive/131927

= XL7: Item Entered as Displayed on Pick List =

PSS ID Number: 131927

Article Last Modified on 3/21/2001

-

The information in this article applies to:


 * Microsoft Excel for Windows 95 7.0

-



This article was previously published under Q131927







SYMPTOMS
In Microsoft Excel, when you use the Pick From List command to enter data in a cell, if you select an item that has been entered as text (by preceding the value with an apostrophe character), the item is entered as a value, instead of as text.

For example, if you type the following in cell A1

'=Test

and if you use the Pick From List command to enter this item in cell A2, the item is entered as =Test (without the apostrophe) and cell A2 displays the #NAME? error value because the name "Test" is not defined in the workbook.



CAUSE
When you enter a value on your worksheet as text by preceding the value with the apostrophe character, the value appears in the list of available items when you use the Pick From List command. This behavior occurs with numbers, dates, and formulas, which are items that normally don't appear in this list. However, when you choose an item that has been entered as text with the apostrophe character, the apostrophe is removed, and the item is entered as a value (that is, as a number, date, or formula).



STATUS
Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

Keywords: KB131927

Technology: kbExcel95 kbExcel95Search kbExcelSearch kbExcelWinSearch

-

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

© 2004 Microsoft Corporation. All rights reserved.