Results 1 to 5 of 5
  1. #1
    Lounger
    Join Date
    Feb 2005
    Location
    Florida, USA
    Posts
    38
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel Date in a cell in 2 lines (2000)

    Hi all,

    I tried to enter a date in a cell so it will appear in 2 lines like:

    Sunday
    January 1, 2008

    Couldn't figure out the custom cell format.

    Is it possible to have it in one cell?

    Thanks in advance for any help.

    -Tivoli0

  2. #2
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Excel Date in a cell in 2 lines (2000)

    When you set up the date in Format|Cells, Number Tab, do the following:

    In the Custom Category:
    Type dddd and then press CTRL + J (this will force a text wrap in the dialog
    Then continue to type mmmm dd, yyyy
    Choose the Alignment Tab and force a Text Wrap
    Press Enter
    Drag the row height wider and widen the column (if necessary)
    Regards,
    Rudi

  3. #3
    Lounger
    Join Date
    Feb 2005
    Location
    Florida, USA
    Posts
    38
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel Date in a cell in 2 lines (2000)

    Rudi,

    Thanks a million!!!

    What a classic solution, you guys are the best!

    -Tivoli0

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Excel Date in a cell in 2 lines (2000)

    Just a caveat abut this method. Many want to use it to narrow the column width. This is not possible.

    The column must still be wide enough to display the entire formatted text (without the wrapping). Otherwise the display will be "################" indicating that the column width is too narrow for the format.

    The trigger for the "too narrow" indication is not sophisticated enough to take wrapping into account and only works on the full length of the formatted display string.

    Steve

  5. #5
    Lounger
    Join Date
    Feb 2005
    Location
    Florida, USA
    Posts
    38
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel Date in a cell in 2 lines (2000)

    Hi Steve,

    You're right about that, I've noticed it.
    However, luckily I didn't have to care about that in this scenario.

    Thanks for your input!

    -Tivoli0

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •