Hi all

I need to enter numbers into a column with the following format 1-21 (a
number, then a dash, then another number).

When I do this, Excel changes the numbers into dates. I have tried creating
a custom number but this still doesn't work. The only method I have found
which works is to create a custom number format for every single cell,
entering the exact number in the 'type' box.

Is there a quicker way???

Thank you
Louise