XL2000: Some List Elements Ignored When You Create Custom Lists (214276)
The information in this article applies to:
This article was previously published under Q214276 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: 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.
STATUSMicrosoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article. MORE INFORMATION
You can create a custom fill series or sorting order from existing items that you have listed on a worksheet, or you can type the list from scratch.
REFERENCESFor more information about AutoFill, click Microsoft Excel Help on the
Help menu, type autofill in the Office Assistant or
the Answer Wizard, and then click Search to view the topics
returned.
| Modification Type: | Major | Last Reviewed: | 9/27/2003 |
|---|
| Keywords: | kbbug kbpending KB214276 |
|---|
|