I have a column, actually of screen resolutions with thousands of rows that look something like this:
<colgroup><col width="64" style="width:48pt"> </colgroup><tbody>
</tbody>
I would like to know the screen area hence add "=" in front of each value.
I did this using concatenate but it just displays the forumla (e.g. "=943*530) and does not in fact do any calculation.
How do I get around this to show the calculated values?
943*530 |
953*572 |
969*768 |
986*1236 |
999*599 |
<colgroup><col width="64" style="width:48pt"> </colgroup><tbody>
</tbody>
I would like to know the screen area hence add "=" in front of each value.
I did this using concatenate but it just displays the forumla (e.g. "=943*530) and does not in fact do any calculation.
How do I get around this to show the calculated values?