XL98: Some List Elements Ignored When You Create Custom Lists (191158)
The information in this article applies to:
- Microsoft Excel 98 Macintosh Edition
This article was previously published under Q191158 SYMPTOMS
When you import a custom list from a range of cells on a worksheet, you
may receive the following message:
Cells without simple text were ignored.
After you receive this message, your list is imported, but it is missing some
elements.
CAUSE
This problem occurs because the list contains a mixture of text and
numbers. If the list contains all text or all numbers, the list is imported
correctly.
WORKAROUND
To work around this problem, enter the numeric elements into the worksheet
as text.
Note, however, that if you use this workaround, AutoFill will only be able
to match your data with the custom list if the numbers in the data are
entered as text.
NOTE: In Microsoft Excel, to enter a number as text, you must first type an
apostrophe ('). You cannot use the Text number format to format numbers as
text.
STATUS
Microsoft has confirmed this to be a problem in the Microsoft products
listed at the beginning of this article.
MORE INFORMATION
Custom Lists are used with the AutoFill feature in Microsoft Excel.
AutoFill is used to automatically enter data on a worksheet. If you
frequently use lists or special series of data, you can create a custom
list to be used with AutoFill.
| Modification Type: | Major | Last Reviewed: | 9/11/2002 |
|---|
| Keywords: | kbprb KB191158 |
|---|
|