Thread: autofill limits
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Tom Hutchins Tom Hutchins is offline
external usenet poster
 
Posts: 1,069
Default autofill limits

You could separate the text from the numerical part of the entry, then
autofill the numerical part. That should allow you to autofill as high as you
want (until you run out of rows or exceed Excel's 15 digits of precision).
Then copy the text portion down and concatenate the text back with the
numbers.

Hope this helps,

Hutch

"Candy" wrote:

Excel autofill does not work with large numbers with text in front. I can
get it to work with the number smaller than MT800225000 but if it is larger -
MT800225000300, it will not sequence the numbers. Are there limitations to
the amount of text characters that will work? If so what are the alternatives?