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.
How to Assign Names to Cells in Excel. Assigning names to cells in Microsoft Excel simplifies referencing the cell or cell range. As an example, instead of referencing =Sheet1!$D$1:$K$23, you can define the name data and use that as a reference.This reduces potential errors from mistyping a range, and saves time referencing difficult-to-remember ranges.tep 2. Click and drag your mouse cursor across the cells you wish to name to select them. Related Reading: How to Find the Percentage of Two Cells in Microsoft Excel. Step 3. Right-click any selected cell and click Define Name.. Step 4. Enter a name for the range in the Name field.