The information in this article applies to:
SYMPTOMSWhen using the autofill feature of Microsoft Excel to fill a text and number combination beyond the number 65535, Microsoft Excel will restart the numbering at zero. CAUSEThis is a limitation of the autofill feature. It does not affect the autofill of numbers, only text and number combinations. STATUSThis limitation does not exist in later versions of Microsoft Excel. WORKAROUND
To work around this limitation, concatenate a column of text and a
column of numbers together as in the following example:
Steps to Reproduce Problem
REFERENCES"Microsoft Excel User's Guide 1," version 4.0, pages 122-130 Additional query words: auto fill
Keywords : |
Last Reviewed: March 23, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |