| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
create numbered sortable numbered list in excel
Excel changes my numbered list to a date! I try to type 1,1-2,1-3,1-4,1-5...
how do I turn off this feature? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
create numbered sortable numbered list in excel
Two options:
a) pre-format the cells as text b) preface the entry with single quote (apostrophe) which will not be seen on screen or in print best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "coloradio" wrote in message ... Excel changes my numbered list to a date! I try to type 1,1-2,1-3,1-4,1-5... how do I turn off this feature? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
create numbered sortable numbered list in excel
Format the cells as text *before* you enter the codes
-- Kind regards, Niek Otten Microsoft MVP - Excel "coloradio" wrote in message ... | Excel changes my numbered list to a date! I try to type 1,1-2,1-3,1-4,1-5... | how do I turn off this feature? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create database in excel? | New Users to Excel | |||
| Excel should let me create an automated list of the name box | Excel Discussion (Misc queries) | |||
| How can Excel create a list of tabs on a worksheet? | Excel Discussion (Misc queries) | |||
| How do I create a list of sequential numbers using Excel or Acces. | Excel Discussion (Misc queries) | |||
| If I create a random list in Excel, does it repeat numbers? | Excel Worksheet Functions | |||
Linear Mode
