Thread Tools Rate Thread

# showing 2 numbers in a cell

Bockhamptoner
Guest
Posts: n/a

 12th Apr 2010
I think I have seen an example where you have 2 seperate pieces of
information in a single cell.
I run a hockey team and use excell to track players and who is available for
matches and then who's played....really basic stuff. But I would like to also
record in the cell if anyone scored and if so how many.
So if I could have my 'ideal world' my cell would containg a 'P' so I know
who played but it would have a diagonal line across the corner and small
number in the triangle....... possible? or ludicrous?
If I were to really get 'everything' I could also choose to tally up the
triangle numbers in a totals column at the end of the year.....daring I know

I've avoiding the obvious....well just type P or P1 or P2 etc because I
couldn't find a way to tally them.

Thanks,

Dave Peterson
Guest
Posts: n/a

 12th Apr 2010
You may be able to fiddle with a diagonal border and alt-enters (and space
characters) to make it look nice.

But don't do it. You're going to find that this makes any calculation much more
difficult.

Just use two cells.

You'll be happier in the long run.

Bockhamptoner wrote:
>
> I think I have seen an example where you have 2 seperate pieces of
> information in a single cell.
> I run a hockey team and use excell to track players and who is available for
> matches and then who's played....really basic stuff. But I would like to also
> record in the cell if anyone scored and if so how many.
> So if I could have my 'ideal world' my cell would containg a 'P' so I know
> who played but it would have a diagonal line across the corner and small
> number in the triangle....... possible? or ludicrous?
> If I were to really get 'everything' I could also choose to tally up the
> triangle numbers in a totals column at the end of the year.....daring I know
>
>
> I've avoiding the obvious....well just type P or P1 or P2 etc because I
> couldn't find a way to tally them.
>
> Thanks,

--

Dave Peterson

JLatham
Guest
Posts: n/a

 13th Apr 2010
I second the Dave Peterson Solution. Use 2 cells. When you consider that
you're going to be putting a single letter into 1 column and mostly only 1
digit into the other column (or you have a world class hockey player on board
and need to enter 2 digits), then the total width of the 2 would probably be
no more than if you managed to futz around with a diagonal line and figure
out how to reliably get P over on the left edge and a digit or two over at
the right edge.

Basically you cannot physically split a single cell into two -- it would
then become 2 columns. And as you noted, by having the P and the score in a
single cell really creates a headache when it comes time to figure out total
points scored by anyone at all.

"Bockhamptoner" wrote:

> I think I have seen an example where you have 2 seperate pieces of
> information in a single cell.
> I run a hockey team and use excell to track players and who is available for
> matches and then who's played....really basic stuff. But I would like to also
> record in the cell if anyone scored and if so how many.
> So if I could have my 'ideal world' my cell would containg a 'P' so I know
> who played but it would have a diagonal line across the corner and small
> number in the triangle....... possible? or ludicrous?
> If I were to really get 'everything' I could also choose to tally up the
> triangle numbers in a totals column at the end of the year.....daring I know
>
>
> I've avoiding the obvious....well just type P or P1 or P2 etc because I
> couldn't find a way to tally them.
>
> Thanks,

 Thread Tools Rate This Thread Rate This Thread: 5 : Excellent 4 : Good 3 : Average 2 : Bad 1 : Terrible

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are Off Forum Rules

 Similar Threads Thread Thread Starter Forum Replies Last Post Bongo Microsoft Excel Worksheet Functions 1 6th Nov 2009 07:25 PM =?Utf-8?B?RWNob2dyYW1teQ==?= Microsoft Excel Misc 7 17th Aug 2006 12:35 AM =?Utf-8?B?RGVlcm5hZCBDb25zdHJ1Y3Rpb24=?= Microsoft Excel Misc 12 29th Nov 2005 08:32 PM StargateFanFromWork Microsoft Excel Programming 4 14th Jul 2004 01:03 PM =?Utf-8?B?bWFydG1hbg==?= Windows XP Help 2 16th Jan 2004 03:40 AM

Features

Advertising

Newsgroups

All times are GMT +1. The time now is 11:02 PM.