LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old August 14th 19, 11:56 AM
Junior Member
First recorded activity by ExcelBanter: Aug 2019
Posts: 1
Question AutoFill Problem with single letter and numbers, without using formula or custom list

I'm trying to autofill the following and it keeps repeating, without using a formula, only formatting, can someone help please?
when I put in: a20170000001, a20170000002, a20170000003, a20170000004, it only repeats.
I can't use a custom list, as the fields will never repeat, only grow.
the only items changing will be the numeric value at the end, going up to possibly 90,000 (ie; a20170090000)

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Autofill of single cells Dannie Excel Discussion (Misc queries) 2 October 20th 08 07:24 AM
creating a custom list of numbers Louise Excel Worksheet Functions 5 November 22nd 06 07:58 PM
Single formula to 'sort' a list onto a second sheet? KR Excel Worksheet Functions 2 May 19th 06 02:08 PM
How can I add a single letter to text already in a list of cells? Gazivaldo New Users to Excel 3 November 16th 05 05:24 PM
Q. Autofill question: Can I autofill alpha characters like I can numbers? George[_22_] Excel Programming 5 August 7th 04 10:33 AM

All times are GMT +1. The time now is 08:27 PM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.

About Us

"It's about Microsoft Excel"


Copyright © 2017