Custom Lists using Numbers

C

CY

I would like to create a custom list that I can use with AutoFill that
consists of numbers (that are employee numbers) but they are non-sequential,
but I need them in a specific order. E.g. 301,304,306,307,309,314,321, so
that if I type 301 the autofill will continue the list for me. Is this
possible?

TIA.

CY
 
P

papou

Hi CY
This will not be possible with Autofill because your list is made of
numbers.
An alternative would be to amend your employee numbers so that they become
text e.g. EN301, EN304 and so on.
In which case you could use the Tools, Options, Custom lists feature and
create a new custom list from these entries.
See if this helps.

Cordially
Pascal
 
D

Debra Dalgleish

Choose Tools>Options
Select the Custom Lists tab
In the List Entries box, type your list of numbers in a column
Click OK
 
Top