Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,203
Default showing 2 numbers in a cell

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel cell showing Yr/Mo/Day in numbers only (09/11/06) can it b. Bongo Excel Worksheet Functions 1 November 6th 09 06:25 PM
showing numbers as percentages MELCHAUV Excel Worksheet Functions 6 April 30th 08 09:37 PM
Why is one cell showing numbers in blue and how do I change that? Echogrammy Excel Discussion (Misc queries) 7 August 17th 06 12:35 AM
Adding numbers in one cell and showing total in seperate cell Deernad Construction Excel Discussion (Misc queries) 12 November 29th 05 07:32 PM
showing negative numbers dzeitler Excel Discussion (Misc queries) 2 June 8th 05 05:30 PM


All times are GMT +1. The time now is 03:34 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"