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.
If you only want to display a month name, you don't need a formula â you can use a custom number format. Select the date and navigate to Format cells (Ctrl + 1 or Cmd +1), then select Custom and enter one of these custom formats: mmm // Jan mmmm // January.
Setting up a Named Range is a two-step process. You first Define the Name, and then you Apply it. To Define your name, do this (make sure you have the formula in cell B5): 1  Highlight the cells B2 to B4 (NOT B5), then click the Formulas menu. 2  Locate the Named Cells panel in Excel 2007.3  In Excel 2010 and 2013, locate the Defined Names panel instead.ou first Define the Name, and then you Apply it. To Define your name, do this (make sure you have the formula in cell B5): 1  Highlight the cells B2 to B4 (NOT B5), then click the Formulas menu. 2  Locate the Named Cells panel in Excel 2007.