Microsoft KB Archive/214276

= XL2000: Some List Elements Ignored When You Create Custom Lists =

Article ID: 214276

Article Last Modified on 9/27/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



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.



STATUS
Microsoft 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.

