Adding a hyphen

[stattad]

Can someone give me an easy way to put a hyphen between two numbers, such as with wins and losses of teams? I want it to come out 5-3, not 5 3.

I tried entering a text box with no success.

 

[supercharge]

OldNumber is 2-digit number.

NewNumber = Left(OldNumber,1) & "-" & Right(OldNumber,1). There should be even a quicker way, standby...

 

[stattad]

It sounds like I have to run this query after my original query? There are 20 numbers in my query, and nine different hyphens in various places. I'm not sure this would work.