XL7: Item Entered as Displayed on Pick List

The information in this article applies to:

• Microsoft Excel for Windows 95, version 7.0

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

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.