Article ID: 191158
Article Last Modified on 9/11/2002
APPLIES TO
- Microsoft Excel 98 for Macintosh
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.
Additional query words: XL98
Keywords: kbprb KB191158