Microsoft KB Archive/134940

= Some List Elements Ignored When You Create Custom Lists =

Article ID: 134940

Article Last Modified on 8/15/2005

-

APPLIES TO


 * Microsoft Excel 97 Standard Edition
 * Microsoft Excel 95 Standard Edition
 * Microsoft Excel 5.0 Standard Edition

-



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.

