Values in one cell.

  • Thread starter Thread starter Raymond
  • Start date Start date
R

Raymond

I want to put several values in a single cell. Something that will display
like this: 5+6+12. Later, I would add these values to another value from
another cell. However, I can't do this because excel won't regconize the
way I want to display mutiple values in a cell like the one from above.
When I add, it only displays the value of the other cell, not the values
from above plus the other cell. How do I fix this?

Thanks.
 
Hi Raymond

if you type
=5+6+12+A1
(where A1 is the other cell that you want to add into this cell)

you will see the result of the calculation in the cell. However, clicking
on the cell will display the actual formula in the formula bar - these can
even be viewed on the sheet or printed by choosing Tools / Options - View
tab .. and clicking the Formulas button.

AFAIK this is the best you'll get in Excel.

Hope this helps
Cheers
JulieD
 
Back
Top