LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 217
Default creating a custom list of numbers

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
 
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
custom section of filter list? Mon Excel Discussion (Misc queries) 1 August 17th 06 11:06 AM
Creating a List based on your choice from Another List Cristi Excel Discussion (Misc queries) 1 August 14th 06 06:00 PM
auto updating list Larry Excel Worksheet Functions 8 July 27th 06 01:59 PM
How to identify a list of numbers as a publisher field mmcdowell Excel Discussion (Misc queries) 1 March 17th 06 09:25 AM
Creating custom list with a comma in it barnabel Excel Discussion (Misc queries) 6 January 10th 06 06:14 AM


All times are GMT +1. The time now is 12:16 AM.

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

About Us

"It's about Microsoft Excel"