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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

lookup command 1
How to Create a Date Series across a row? 3
Series fill only copying and fill series greyed out 1
How to set cell value to emptry if three other columns are empty too 1
Formula to govern Print Area 2
Exponential Series 3
Using the a date in A concatenate formula 3
nesting functions to compare segments of two columns 1

Back
Top