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.
Growing Dividend Payout Concerns at AT&T. AT&T Inc. (NYSE: T) is the top stock in the Dogs of the Dow. Its sliding shares price is down to a 52-week low, and now AT&Tâs dividend yield is a whopping 5.55%. This is almost an unheard of dividend for a Dow Jones Industrial Average stock.