1 Use the fill handle or copy and paste to copy the VALUE function in cell E1 to cell E2. 2  The number 20 should appear in cell E2 and be aligned on the right side of the cell. 3  Type =SUM(E1: E2) into cell E3 and press the Enter key on the keyboard.4  An answer of 30 should appear in cell E3.onverting the Text Data to Numbers with the VALUE Function. 1  Click on cell E1 in the worksheet. 2  Click on the Formulas tab of the ribbon menu. 3  Choose Text from the ribbon to open the function drop down list. 4  Click on VALUE in the list to bring up the function's dialog box. 5  In the dialog box, click on the Text line.
Wall Street doesn't seem to think the marriage of AT&T and Time Warner is a smart move -- particularly at this price. AT&T's $107.50 a share offer for the company is 19% higher than where Time Warner's stock is trading currently, and 35% over where it was before the rumors started.
The deal values each Time Warner Cable share at approximately $195.71 based on Charterâs market closing price on May 20, or approximately $200 based on Charterâs 60-trading day volume weighted average price.