View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
pinmaster pinmaster is offline
external usenet poster
 
Posts: 347
Default 2 Values in 1 Cell

Wondered what that noise was :)

Glad I could help!

Cheers!
Jean-Guy

"Keith J." wrote:

The noise you heard was me "oooohhhhhhh" "SMACK" (hand hitting forehead).
Funny thing is I knew the "alt" but never went the next step!!!! THANKS!!!!

"pinmaster" wrote:

Hi

Try this: type your first number then hit the ALT+ENTER keys, that will add
a carriage return to the cell next add some blank characters (space bar)
followed by your second number or vise versa depending on which corner you
want your numbers next format your cell with a diagonal line.

Hope this helps!
Jean-Guy

"Keith J." wrote:

I am looking to create a table w/o forumlas that will allow me to put two
separate values in the same "cell". In other words my idea is for it to look
like this:

___________
| #1 / |
| / |
| / |
|__/__#2___|

I don't care if it is one cell or two merged ones or however it can be done.
I cannot seem to ask online help or this newsgroup search the right
question. The only answer I can seem to find is one that says you cannot
have two values in one cell. Any way around that? THANKS!!