Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to have two seperate data in one cell
example : sales quantity at left upper corner and cumulative sales quantity
at lower right corner. the cell being divided to two, by a diagonal line. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to have two seperate data in one cell
You can only do this using drawing objects and will not be able to do any
calculations on the data., so why do it? "TanjuE" wrote: example : sales quantity at left upper corner and cumulative sales quantity at lower right corner. the cell being divided to two, by a diagonal line. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to have two seperate data in one cell
you can display like you want but there are limtations.In the cell you want
to display your combinations draw your borders and a diagonal line.It works best if the cell is about twice as high as the std excel setting.Have your vertical alignmebt set to centre,and get your numbers into the cell from two other cells like =A1&" "&A2.You can use your original cells for any caculations.You will need to experiment with he number of spaces " " depending on your data.or have a dynamic fomula using len() and find() and rept() and substittute() -- paul remove nospam for email addy! "Toppers" wrote: You can only do this using drawing objects and will not be able to do any calculations on the data., so why do it? "TanjuE" wrote: example : sales quantity at left upper corner and cumulative sales quantity at lower right corner. the cell being divided to two, by a diagonal line. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to have two seperate data in one cell
.... My error as you can use the diagonal border but it is "Read only" i.e.
cannot use data for calculations. "Toppers" wrote: You can only do this using drawing objects and will not be able to do any calculations on the data., so why do it? "TanjuE" wrote: example : sales quantity at left upper corner and cumulative sales quantity at lower right corner. the cell being divided to two, by a diagonal line. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to have two seperate data in one cell
Hi Tanjue
Yes Paul is right you can display like you want but there are limtations try this, after typing one figure press alt+enter then type next figure but it wont perform any calculation it assumes text. please correct me if I am wrong. "paul" wrote: you can display like you want but there are limtations.In the cell you want to display your combinations draw your borders and a diagonal line.It works best if the cell is about twice as high as the std excel setting.Have your vertical alignmebt set to centre,and get your numbers into the cell from two other cells like =A1&" "&A2.You can use your original cells for any caculations.You will need to experiment with he number of spaces " " depending on your data.or have a dynamic fomula using len() and find() and rept() and substittute() -- paul remove nospam for email addy! "Toppers" wrote: You can only do this using drawing objects and will not be able to do any calculations on the data., so why do it? "TanjuE" wrote: example : sales quantity at left upper corner and cumulative sales quantity at lower right corner. the cell being divided to two, by a diagonal line. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ranking query | Excel Discussion (Misc queries) | |||
Cell data format | Excel Discussion (Misc queries) | |||
Maximum data in cell | Excel Discussion (Misc queries) | |||
Input cell reference is not valid (One Variable Data Table) | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |