Mr.Louise
i am new person for this forum. anyway i think my answer is useful for u
your number for ex. 1-21 is the result but u use this number for 2
columsn like

A B RESULT
1 21 = CONCATENATE (A1,"-",B1)

21 141 = " ( SAME FORMULA USE) U will get 21-141
very easy mathod after finish you work result colum just copy and paste
special there only in values you will get result easy , there is no
restriction for digits.

colulmn A and column B filling is depend upon ur s request number "-"
symbol automatic generated n formulae. ( )
check and send a mail how it is working ok

"Louise" wrote:

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