Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA: For Count, when count changes from cell to cell | Excel Discussion (Misc queries) | |||
Compiling macro based on cell values | Excel Discussion (Misc queries) | |||
Help with this conditional IF statement | Excel Discussion (Misc queries) | |||
Replacing Linked Cell Values w/ Current Values | Excel Worksheet Functions | |||
Possible Lookup Table | Excel Worksheet Functions |