Multiple data per cell

[Dan]

Is it possible to have 2 numeric values in a cell and to
be able to manipulate (e.g. sum) them separately. If so,
how. Thanks.

 

[Paul Corrado]

Dan,

Yes, but it makes every calculation you would want to perform complicated,
and the formulae much longer than they would otherwise need to be.

If all you wish to accomplish is to display two different pieces of
numerical information it may be better to place the data elsewhere in the
spreadsheet and use a reference such as =C1&" / "&D1

In this case if C1 contained 123 and D1 contained 77 this formula would
show 123 / 77

HTH

PC