Fill series inconsistent

  • Thread starter Thread starter Keith
  • Start date Start date
K

Keith

Using Excel 2002, if cell A1 contains "I1 03462500052" and
cell A2 contains "I1 03462500053", then I can use the fill
series option to fill in cell A3 with "I1 03462500054",
and so on. However, if cell A1 contains "I1 04462500052"
and cell A2 contains "I1 04462500053", then the fill
series option will be greyed out. It seems that the
change from "034" to "044" in these numbers causes a
problem. Any ideas as to why? Thank you!
 
There was a previous discussion that boiled down to big numbers make autofill
choke. (I don't recall what that big number was, but it was between 0346250052
and 04462500052!

Maybe an alternate solution would work for you:

="I1 044625"&TEXT(ROW()+51,"00000")

And drag it down.
 
Back
Top