number formatting

[Guest]

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

 

[Dave Peterson]

Maybe just select the range to fill
format|cells|Number tab|Custom category
0-00

And then just enter your 3 digits (no dashes).

If you do this, the values will still be numeric (121), but will show 1-21.

If you want the values to include the dash, you can format the cells as Text and
then type exactly what you want or just precede your entry with an apostrophe:
'1-21

 

[Guest]

That worked a treat, thank you!!

(Just out of curiosity, if some of the figures were 5 digits rather than 3,
is there a way around this), ie. some are 1-22 but some could be 12-434.

Thanks again.
Louise

 

[Dave Peterson]

You can still use the text stuff or you could use a custom format of:

[<1000]0-00;00-000

 

[Epinn]

Dave,

I have a question from this thread. If you have time would you mind helping me? It is in the Newusers forum. Subject: custom format. 11/22/2006

Appreciate clarification. Thanks.

Epinn

You can still use the text stuff or you could use a custom format of:

[<1000]0-00;00-000

 

[Guest]

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. ( (e-mail address removed))
check and send a mail how it is working ok