Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel cell showing Yr/Mo/Day in numbers only (09/11/06) can it b. | Excel Worksheet Functions | |||
showing numbers as percentages | Excel Worksheet Functions | |||
Why is one cell showing numbers in blue and how do I change that? | Excel Discussion (Misc queries) | |||
Adding numbers in one cell and showing total in seperate cell | Excel Discussion (Misc queries) | |||
showing negative numbers | Excel Discussion (Misc queries) |