Thanks for your reply, however, I tried that but when I drag it across, it
fills in the next numerical number, not the one from my list.

Do I need to do anything else??

Louise

"Nick Hodge" wrote:

Louise

If these 'numbers' are not going to be used in calculations e.g part
numbers, then prefix with a single apostrophe ' and you will be able to set
up the list (The apostrophe won't show)
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk


"Louise" wrote in message
...
Hi all

I have created several custom lists using Tools|Options|Custom Lists,
however, I would like to create one which consists of numbers rather than
words. The numbers I want to use are not in any particular order and are
4-digits long.

I have tried to create these but when I try to use it as a list, Excel
simply increments the original figure by one, as if it doesn't recognise
it
as part of a list.

Is it possible to create custom lists which consist of numbers?

Thank you.
Louise