create numbered sortable numbered list in excel

C

coloradio

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?
 
B

Bernard Liengme

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
 
N

Niek Otten

Format the cells as text *before* you enter the codes

--
Kind regards,

Niek Otten
Microsoft MVP - 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?
 
Top