#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default 2 Values in 1 Cell

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!!
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 347
Default 2 Values in 1 Cell

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!!

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 303
Default 2 Values in 1 Cell

You would need to pre- format the cells to be text in stead of general

If you do want the different levels in the cell, use <alt<enter after
entering the /

Greetings from New Zealand

"Keith J." wrote in message
...
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!!



  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default 2 Values in 1 Cell

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!!

  #5   Report Post  
Posted to microsoft.public.excel.misc
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!!

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
VBA: For Count, when count changes from cell to cell LenS Excel Discussion (Misc queries) 18 January 4th 07 12:53 AM
Compiling macro based on cell values simonsmith Excel Discussion (Misc queries) 1 May 16th 06 08:31 PM
Help with this conditional IF statement C-Dawg Excel Discussion (Misc queries) 3 May 15th 06 06:01 PM
Replacing Linked Cell Values w/ Current Values TomCat Excel Worksheet Functions 6 April 10th 06 12:20 PM
Possible Lookup Table Karen Excel Worksheet Functions 5 June 8th 05 09:43 PM


All times are GMT +1. The time now is 05:04 PM.

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

About Us

"It's about Microsoft Excel"