The Trumps' wedding ceremony and reception were widely covered by the media. Trump wore a $200,000 dress made by John Galliano of the house of Christian Dior. In 2006, Melania gave birth to a son named Barron William Trump. Donald suggested his first name and Melania his middle name. As an infant, Barron reportedly occupied his own floor in the Trumps' apartment in Trump Tower in Manhattan, but often slept in a crib in his parents' bedroom.
Method 1: Convert month name to number with formula. Type this formula =MONTH(DATEVALUE(A1& 1)) ( A1 indicates the cell that you want to convert the month name to number, you can change it as you need) into a blank cell, and press Enter key.
Row 11 shows the change from the prior month. Each formula in Row 11 is the result of subtraction using the â-â (hyphen) as a minus sign. To create the formula in cell D11: 1  Click on cell D11. 2  Click in the formula bar. 3  Type â=â to tell Excel that you are beginning a formula. 4  Type âD9-C9â.  Press Enter.