How to convert a chain into a number In Apple Numbers I want a cell to have 4x8x7 (or 4*8*7) to show the detail of the volume, and in another cell I want that volume calculated 4*8*7=224 based on the first cell. But it doesn't consider the first cell as an operation. Which formula can help ?
You could use the string concatenation operator '&amp;' and make a formula like this:

=B2&amp;" X "&amp;B3&amp;" X "&amp;B4
which would display "4 X 8 X 7"

then have another formula that actually calculates the function:

=B2*B3*B4
which would display "224"

http://i.imgur.com/9ggakhc.png