As ALWAYS, post your efforts for comments


--
Don Guillett
SalesAid Software

"ChrisL" wrote in
message ...

I have what I hope will be a nice easy question for you guys... :)

I'm putting together a worksheet for our local sports league. I want to
append the scores from two cells together with a - in between them (e.g.
2-1), which works fine unless the 2nd score is a zero, in which case it
ignores the - (e.g. 20). How can I get it to display the - all the
time?

I can't change the formatting of the cells, because if the score is
blank (i.e. the match is in the future), then the new cell displays the
date of the match.

I hope that makes sense... :) ,
Chris L


--
ChrisL
------------------------------------------------------------------------
ChrisL's Profile:
http://www.excelforum.com/member.php...o&userid=37767
View this thread: http://www.excelforum.com/showthread...hreadid=573439