Some List Elements Ignored When You Create Custom Lists (134940)
The information in this article applies to:
- Microsoft Excel 97 for Windows
- Microsoft Excel for Windows 95
- Microsoft Excel for Windows 5.0
This article was previously published under Q134940 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.
REFERENCES
"User's Guide" version 5.0, Chapter 9, "Customizing AutoFill"
For more information about AutoFill, click the Search button in Help and
type:
| Modification Type: | Minor | Last Reviewed: | 8/15/2005 |
|---|
| Keywords: | kbbug kbpending KB134940 |
|---|
|