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.
Beginning Sunday, customers can choose the new Mobile Share Advantage plan and pay for extra data, if needed, or work with slower data speeds instead of paying for overages, the company said in a statement. Its current plan includes a $5 data overage charge per 300 megabytes on its 300-megabyte plan and $15 per 1 gigabyte on other plans. AT&T (t) and its rivals are locked in an aggressive battle for subscribers in the saturated U.S. wireless market.