View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default showing 2 numbers in a cell

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