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.

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.

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.

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.

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.